Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Program line when charting variances?
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Greg -
Try one of these approaches: http://peltiertech.com/Excel/Charts/AddLine.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Greg Strong wrote: Sorry should have cross posted to begin w ith. 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! |
#4
|
|||
|
|||
On Sat, 26 Mar 2005 12:07:43 -0500, Jon Peltier
wrote: Try one of these approaches: http://peltiertech.com/Excel/Charts/AddLine.html I got it to work with text. With some additional formulation, I can make min and max point values for vertical line at variance = 0. Thanks! -- Regards, Greg Strong |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting lines between data points in a line chart | Charts and Charting in Excel | |||
Custom charting - Stacked charting with a line | Charts and Charting in Excel | |||
Line and Column Graph | Charts and Charting in Excel | |||
Is there a program in office to create a line graph? | Excel Discussion (Misc queries) | |||
Line chart - date line association gone mad! | Charts and Charting in Excel |