Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting,microsoft.public.excel.programming
|
|||
|
|||
Program line when charting variances?
Sorry should have cross posted to begin with.
Hello All, Is it possible to program a vertical line when charting variances? My Y axis is either variance dollars or variance percentage. My X axis is for what I'm charting variances. For example my X axis could be apple types. In my data series I sort my Y variable from best to worst, and I'm using a bar chart. My sample data could be as follows: Apple Type Variance $ ------- ----------- Apple 1 1000 Apple 2 750 Apple 3 100 Apple 4 -400 Apple 5 -750 So I would like to draw a vertical line between Apple 3 and Apple 4. For the readers of the graph the vertical line becomes a driver. Simply stated I have my good apples to the left of the line, & the bad apples to the right of the line. So if Apple Type represents one product group and there are many product groups to graph, then there are a lot of graphs to add a vertical line to manually at the end of each period. Any ideals? TIA! -- Regards, Greg Strong -- Regards, Greg Strong |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charting a line and a bar on the same chart | Charts and Charting in Excel | |||
charting variable line data | Excel Discussion (Misc queries) | |||
In-line charting | Charts and Charting in Excel | |||
Program line when charting variances? | Charts and Charting in Excel | |||
Custom charting - Stacked charting with a line | Charts and Charting in Excel |