ExcelBanter - Changing Y axis scale

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

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Changing Y axis scale (https://www.excelbanter.com/charts-charting-excel/20055-changing-y-axis-scale.html)

John

Changing Y axis scale

I have created a chart that has the following data:

50
45
35
25
The y scale starts at 0 and goes to 100. How do I change the scale?
--
Thanks,

John

Andy Pope

Hi,

Double click the Y axis to display the format dialog and then check out
the Scale tab.

Cheers
Andy

John wrote:
I have created a chart that has the following data:

50
45
35
25
The y scale starts at 0 and goes to 100. How do I change the scale?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

All times are GMT +1. The time now is 10:11 AM.