Tag Info

Hot answers tagged

4

The key is to include the date. Without the date, Excel has no basis to know that 23:17:47 was from the previous day. I mocked up a couple of values to illustrate. The date/time values are in column A and the Y values in column B. I selected a scatter plot, which treats the X axis as a continuous variable. The rest is formatting. The X axis shows ...


3

If you want a colored band between the red and blue lines in your example, then use the Filled Radar chart type. You'll have to organize your series from largest to smallest - the reverse of what it is now - and then set the fill for the smallest series to be white. This will give the appearance of just a band of color instead. This solution might not work ...


2

Excel will do this pretty easily: Create your data table with three series: Maximum Positive (e.g. 4.0%) for each category, Maximum Negative (e.g. 0%) for each category and your values. Create a Filled Radar Chart (Excel's terminology) using your three series. Format the Axis to your appropriate minimum and maximum values. Format the Maximum Positive ...


1

When I export from Excel, my .png images are about 1" = 151px. To get a perfect 450px wide image, I set my Chart width to 2.99" (direct enter the value on the Width box on the Format Tab). To verify, paste into MS Picture Manager and check the size setting summary. Then adjust as necessary. FWIW, my Excel 2007 on a different box behaves slightly ...


1

Here are a couple tutorials with some VBA code that will export a chart as an image file: Export Chart as Image File and Enhanced Export Chart Procedure.


1

Consider the following scenario: To calculate the percentage of Pass you need to divide the number of Pass values by the total number of values. The formula in F2 is =COUNTIF(B:B,D2)/(COUNTA(B:B)-1) In words: count how many items in column B equal the text in D2. Divide that by the total number of items in column B, but subtract 1 for the label row. ...


1

Teylyn's answer is good and that approach works for your data. However, I would approach it a little different as a matter of personal preference. I would treat the years as a continuous variable rather than categories. For your data, you get the same result, but if you happened to be missing a year of data, treating it as a continuous variable would ...


1

I've been using http://yUML.me for this sort of thing: For example code like this: // Cool Class Diagram [Customer|-forname:string;surname:string|doShiz()]<>-orders*>[Order] [Order]++-0..*>[LineItem] [Order]-[note:Aggregate root{bg:wheat}] will yield a flow chart like this: It's fully text based, and you can even use the text to make a ...


1

Use a (Y X) Scatter plot. With this chart the values on the time axis don't have to be regular. Select the data to plot Click Insert tab Click Scatter Select the chart type



Only top voted, non community-wiki answers of a minimum length are eligible