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

  • Thread starter Johanna Gronlund
  • Start date
J

Johanna Gronlund

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.
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Horizontal axis to the bottom 1
vertical scale on both ends of bar chart 1
Arithmetic scale in charts 2
Axis scale on X-Y scatter graph 2
Variable or Split vertical axis scales 3
Auto Scale x-axis 1
Dynamically Scale X Axis on Column Chart Based on Number of Catego 1
why my 2nd series scale change? 7

Top