#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 28
Default y axis

I have a chart that auto-formats the values of the intervals of the y axis.
That is fine. However, when I preview the chart, the intervals change and
the chart prints with those changed values.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default y axis

Double click on the axis, and on the Scale tab, enter the scale values you
want the chart to use.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"lily" wrote in message
...
I have a chart that auto-formats the values of the intervals of the y axis.
That is fine. However, when I preview the chart, the intervals change and
the chart prints with those changed values.



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
xy-scatter-labels disappear when x-axis is changed into time-axis (XL07) Holger Gerths Charts and Charting in Excel 8 June 5th 08 04:25 PM
Need PivotChart x axis to cross Y axis at minimum Y axis value Aaron Charts and Charting in Excel 1 August 17th 07 08:51 AM
Excel 2003: Mapping rows (x-axis) vs multiple columns (y-axis) Tom Excel Discussion (Misc queries) 1 May 29th 07 01:03 PM
can I make the vertical axis the category axis in Excel line graph power1 Charts and Charting in Excel 1 March 20th 06 08:45 PM
How to insert X axis scale values next to axis and X axis grid lin vp23larry Charts and Charting in Excel 2 June 23rd 05 03:45 PM


All times are GMT +1. The time now is 01:39 PM.

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

About Us

"It's about Microsoft Excel"