| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
The scale on vertical axis equals to scale on vertical axis ofano
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vertical scroll bar scale | Excel Worksheet Functions | |||
| How to apply the same Fixed Horizontal Scale to Both Vertical Axis | Charts and Charting in Excel | |||
| How to draw chart: log scale on X axis, natural scale on y axis? | Charts and Charting in Excel | |||
| can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel | |||
| How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel | |||
Linear Mode
