ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How to make a break in chart scale? (https://www.excelbanter.com/charts-charting-excel/224132-how-make-break-chart-scale.html)

Katie

How to make a break in chart scale?
 
Does anyone know how to make a break in chart scale?
I am using excel 2007 right now.

Most of numbers are 90-120 and i have only one number that is 10.

so I want to have detailed graph of 90-120 using line graph and make a break
so that I can also show 10.

David Biddulph[_2_]

How to make a break in chart scale?
 
http://peltiertech.com/Excel/Charts/BrokenYAxis.html
That will have been before Excel 2007, but hopefully a similar technique
will apply.
--
David Biddulph

"Katie" wrote in message
...
Does anyone know how to make a break in chart scale?
I am using excel 2007 right now.

Most of numbers are 90-120 and i have only one number that is 10.

so I want to have detailed graph of 90-120 using line graph and make a
break
so that I can also show 10.





All times are GMT +1. The time now is 07:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com