Hi Guys,

I have two stacked column charts which represent scenario A and B. In order
to make those charts visual comparable I would need to determine the y-axis
of chart 2 same as chart 1.
I hope there is a solution!

Thanks!

Hi,

1. You could plot both sets of data on one chart.
2. You can set the max and min values of the axis by double-clicking the
Value axis (Y-axis) and choosing the Scale tab, and typing in the values you
want for the Minimum and Maximum

Same idea different place in 2007
--
cheers,
Shane Devenshire


"Hannes" wrote:

Hi Guys,

I have two stacked column charts which represent scenario A and B. In order
to make those charts visual comparable I would need to determine the y-axis
of chart 2 same as chart 1.
I hope there is a solution!

Thanks!

If the values plotted change regularly, you might want to look at
AutoChart Manager
http://www.tushar-mehta.com/excel/so...art/index.html

In article ,
says...
Hi Guys,

I have two stacked column charts which represent scenario A and B. In order
to make those charts visual comparable I would need to determine the y-axis
of chart 2 same as chart 1.
I hope there is a solution!

Thanks!