Can't change the scale of values on a y-axis on a line chart

A

ags

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!
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scatter chart with categories on x-Axis 2
Labeling on independently stacked line chart 0
Dynamically Scale X Axis on Column Chart Based on Number of Catego 1
Using a 'Name' to Update Chart Titles & "Y" Axis Scale 2
Chart - Secondary Y-axis with different values/scale 2
Excel 2010 - Line Chart with Mulitiple Data Sets 1
Excel 2007: X-axis labeling 1
Making Equal Spacing between --> X-Axis = Y-Axis, in a char 1

Top