Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
ags ags is offline
external usenet poster
 
Posts: 1
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default 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!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Line chart with multiple scales/units along an axis... JohanD Charts and Charting in Excel 3 March 19th 06 04:53 AM
Chart Axis Showing Lapse/Interupt Scale pomalley Charts and Charting in Excel 1 January 7th 06 04:38 AM
tick mark labels Debrane Charts and Charting in Excel 9 July 19th 05 02:53 AM
Chart Axis Scale Auto Values Moses Bunting Charts and Charting in Excel 1 June 7th 05 11:03 PM
Create new series (on the same chart) for every change of values in a combobox uriel78 Charts and Charting in Excel 5 April 15th 05 12:08 AM


All times are GMT +1. The time now is 03:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"