ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Can't change the scale of values on a y-axis on a line chart (https://www.excelbanter.com/charts-charting-excel/103432-cant-change-scale-values-y-axis-line-chart.html)

ags

Can't change the scale of values on a y-axis on a line chart
 
The data are bunched together, so I want to choose a different grid line
display to spread them apart. I changed the parameters in the Format Axis
window but Excel won't accept the changes. Help!

Jon Peltier

Can't change the scale of values on a y-axis on a line chart
 
After entering values, do not check the Auto checkboxes. This tells Excel to
use whatever scaling parameters it wants, and you already do not like those.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"ags" wrote in message
...
The data are bunched together, so I want to choose a different grid line
display to spread them apart. I changed the parameters in the Format Axis
window but Excel won't accept the changes. Help!





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

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