| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Scale on Axes
Is there a way to have 2 scales on one axis?
ie. if one values range from -100 to +30 want the minus to be smaller scale so that the positive values which are the ones I am really interested in are not made so small? -- Ali UK |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Scale on Axes
Hi,
Maybe you can use the broken axis technique for the negative part of the scale. http://www.andypope.info/charts/brokencolumn.htm Cheers Andy Ali wrote: Is there a way to have 2 scales on one axis? ie. if one values range from -100 to +30 want the minus to be smaller scale so that the positive values which are the ones I am really interested in are not made so small? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code about setting Y Axes scale. | Charts and Charting in Excel | |||
| Linking axes scale values to cells | Charts and Charting in Excel | |||
| 2 Axes, same scale wanted | Charts and Charting in Excel | |||
| How do I scale excel chart axes from vb? | Charts and Charting in Excel | |||
| Change Axes Scale Dynamically | Charts and Charting in Excel | |||
Linear Mode
