Graph

[PAL]

Hello,

Can someone please tell me if this is indeed possible? I would like to make
a graph with 2 different Y axis's.

First I would like a stacked bar graph (easy on its own; the total range of
this stacked graph will most likey be from 1-10). Essentially I am
displaying the total number and the individually components of the stack.

To accompany this, I was hoping to show with tick marks (a min and max) the
cost range for implementing the number of changes in the total bar above.
Thus the min and max are dependent on this number,

Is this possible with custom graphs? If so, how? Thanks.

 

[Jon Peltier]

Rather than tick marks, how about drawing min and max lines across the
chart:

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon

 

[PAL]

The Min and Max will vary for each bar. Will this accomplish that? Also, I
will need to keep the axis.

 

[Jon Peltier]

You could try this approach:

http://peltiertech.com/Excel/Charts/ColumnHorizLine.html

No reason you can't have multiple benchmark lines in the same chart.

- Jon