Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I put a break in an axis in a chart?
Is there any way to put a break in an Excel chart axis? I'm using Excel 2003
and Excel XP. I have some graphs where one or more data points is substantially higher than other data points; it's difficult to see the differences between the lower data points. What I would like to do is have the y-axis go from about 0-20, have a break in the graph, and resume the graph at about 40 (my highest data point). |
#2
|
|||
|
|||
How do I put a break in an axis in a chart?
Here's an example and some links to others:
http://peltiertech.com/Excel/Charts/BrokenYAxis.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ pieridae3 wrote: Is there any way to put a break in an Excel chart axis? I'm using Excel 2003 and Excel XP. I have some graphs where one or more data points is substantially higher than other data points; it's difficult to see the differences between the lower data points. What I would like to do is have the y-axis go from about 0-20, have a break in the graph, and resume the graph at about 40 (my highest data point). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart Axis Value | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
Stacked Bar Chart with Secondary Axis | Charts and Charting in Excel | |||
How do I break the value (Y) axis in an Excel chart ?? | Charts and Charting in Excel | |||
Second X axis at top of chart? | Charts and Charting in Excel |