Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How can I add a break in the X or Y axes?
My x axis range is from 0 to 2000000 and my Y values are at 0, 1000, 5000,
10000, 50000, 10000, 200000, 600000 and 2000000. When I plot my values the first 4 data almost over lap with each other and there is a huge gap between the last two data points. So my question is : 1. How can I add a brak in the x-axes (to reduce the gap between last two data points)? 2. How can I expand the x axis (to show the first 4 data points clearly)? I am 99.9% sure that the last option is not possible isn excel. However, if it is and someone know that would be of great help. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How can I add a break in the X or Y axes?
You can use a logarithmic scale, or you could try this technique, which
works for X and Y value axes: http://peltiertech.com/Excel/Charts/BrokenYAxis.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "SanD" wrote in message ... My x axis range is from 0 to 2000000 and my Y values are at 0, 1000, 5000, 10000, 50000, 10000, 200000, 600000 and 2000000. When I plot my values the first 4 data almost over lap with each other and there is a huge gap between the last two data points. So my question is : 1. How can I add a brak in the x-axes (to reduce the gap between last two data points)? 2. How can I expand the x axis (to show the first 4 data points clearly)? I am 99.9% sure that the last option is not possible isn excel. However, if it is and someone know that would be of great help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Two y-axes | Charts and Charting in Excel | |||
Adjusting the y axes on 2-axes line graphs | Charts and Charting in Excel | |||
Break cell into multiple lines by line break | Excel Discussion (Misc queries) | |||
Show 'incomplete' axes & show ticks but NOT axes? | Charts and Charting in Excel | |||
adding a new page break to an existing page break | Excel Discussion (Misc queries) |