Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
On the Y axis how do I make 0-100 big and then 100-500 small?
I have small numbers and then big numbers on the same chart. To better
represent all of the numbers I want 0-100 on the Y axis to be spread out, showing a small intervals from each number, then from 100-500 I want the Y axis to shrink and show large intervals between numbers |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
On the Y axis how do I make 0-100 big and then 100-500 small?
You can make a custom axis using a dummy XY series, then selectively rescale
your data to fit. Here are some examples of custom axis scales: http://peltiertech.com/Excel/Charts/...tml#AxisScales - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Alcoa" wrote in message ... I have small numbers and then big numbers on the same chart. To better represent all of the numbers I want 0-100 on the Y axis to be spread out, showing a small intervals from each number, then from 100-500 I want the Y axis to shrink and show large intervals between numbers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|