ExcelBanter - Scale of Y axis

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Scale of Y axis (https://www.excelbanter.com/excel-discussion-misc-queries/139410-scale-y-axis.html)

Derby

Scale of Y axis

I would like to introduce a break in my Y axis such that my scale is from 0-4
then 40-50 so that I can display a range of data on the same graph.

Barb Reinhardt

Scale of Y axis

Jon Peltier has something here
http://www.peltiertech.com/Excel/Cha...es.html#Broken

"Derby" wrote:

I would like to introduce a break in my Y axis such that my scale is from 0-4
then 40-50 so that I can display a range of data on the same graph.

All times are GMT +1. The time now is 05:56 PM.