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

Hi Greg,

Have a look at Jon's examples
http://peltiertech.com/Excel/Charts/AddLine.html

No need to cross post most posters read multiple NGs anyway.

Cheers
Andy

Greg Strong wrote:
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!


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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!

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