Excel 2000 Chart Y-Axis Scale break
I have a mixed bar/line chart where most of the data is in lower numbers
(none higher than 55,000) but one set of data goes up to 110,000. This one set causes all of the other ones to look very small and the entire top half of the chart only has that 1 data series. Is there a way to use a smaller scale and put a break (jagged lines or something like that) in the y-axis between 60,000 and 100,000 to allow the other data sets to be a little more visible? Thanks! |
Excel 2000 Chart Y-Axis Scale break
You could use a chart with two axis...make a duplicate of your data and
add the duplicate series to the chart. Plot one series on the left axis an the other on the right axis. Format the appropriate parts of each series to have no fill and no borders. You end up with what appears to be one series with part of it scaled to the right axis and the other to the left axis. You could color each axis to match the appropriate data points. -or- Jon Peltier has instructions on creating a "Broken Y Axis" chart here... http://peltiertech.com/Excel/Charts/index.html#hdrAxes (under the Chart Axes and Axis Tricks) -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "-PJ" wrote in message I have a mixed bar/line chart where most of the data is in lower numbers (none higher than 55,000) but one set of data goes up to 110,000. This one set causes all of the other ones to look very small and the entire top half of the chart only has that 1 data series. Is there a way to use a smaller scale and put a break (jagged lines or something like that) in the y-axis between 60,000 and 100,000 to allow the other data sets to be a little more visible? Thanks! |
All times are GMT +1. The time now is 02:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com