The scale on vertical axis equals to scale on vertical axis of ano

Hello,

I have a chart that displays 'before product implementation' scenario and
another one next to it that dispalys 'after product implementation'. The user
will have two countries to choose from so I have to leave the scale on auto
rather than fix it because the the countries have very different size
markets.

What I would like to do is to make the vertical scale of graph 1 equal to
the vertical scale of graph 2 so that I can show the impact of the product
more clearly. Is there a way to do this which doesn't involved fixing the
scales?

Many thanks in advance.

--

Johanna

Hi,

Add a dummy series to each chart that is based on the maximum value from
each set of data. You can then use Auto settings which will be
consistent across both charts

Cheers
Andy

Johanna Gronlund wrote:
Hello,

I have a chart that displays 'before product implementation' scenario and
another one next to it that dispalys 'after product implementation'. The user
will have two countries to choose from so I have to leave the scale on auto
rather than fix it because the the countries have very different size
markets.

What I would like to do is to make the vertical scale of graph 1 equal to
the vertical scale of graph 2 so that I can show the impact of the product
more clearly. Is there a way to do this which doesn't involved fixing the
scales?

Many thanks in advance.


--

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