ExcelBanter - How do I change value of Y axis on graph

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

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

- - How do I change value of Y axis on graph (https://www.excelbanter.com/charts-charting-excel/121659-how-do-i-change-value-y-axis-graph.html)

Al luvs cats

How do I change value of Y axis on graph

Am creating a basic chart for the first time.I need my Y axis to be from 1 to
20.

Andy Pope

How do I change value of Y axis on graph

Hi,

Double click the Y axis. On the scale tab enter the required Maximum value.

Cheers
Andy

Al luvs cats wrote:
Am creating a basic chart for the first time.I need my Y axis to be from 1 to
20.

--

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

Al luvs cats

How do I change value of Y axis on graph

Thanks so much!!!

"Andy Pope" wrote:

Hi,

Double click the Y axis. On the scale tab enter the required Maximum value.

Cheers
Andy

Al luvs cats wrote:
Am creating a basic chart for the first time.I need my Y axis to be from 1 to
20.

--

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

All times are GMT +1. The time now is 02:50 PM.