#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 124
Default Lock Axis Values?

I want to show a progression of data, tracking towards reaching a
predetermined goal. Unfortunately, as I get closer to the desired goal, my Y
axis values are changing every time I update the data, thereby making it look
like I am not getting any closer to the desired goal.

Is it possible to lock in the Axis values, so that they do no autmatically
adjust to "fit" the data provided. Thx.
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Lock Axis Values?

Yes, it is possible to lock in the axis values in Microsoft Excel. Here's how you can do it:
  1. Select the chart that you want to modify.
  2. Right-click on the Y-axis and select "Format Axis" from the drop-down menu.
  3. In the Format Axis pane that appears on the right-hand side of the screen, click on the "Axis Options" tab.
  4. Under "Bounds," you will see two options: "Automatic" and "Fixed." Select "Fixed."
  5. Enter the minimum and maximum values that you want to use for the Y-axis in the "Minimum" and "Maximum" fields.
  6. Click "Close" to apply the changes.

Now, your Y-axis values will remain fixed, regardless of any changes to the data in your chart. This will allow you to track your progress towards your predetermined goal more accurately.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Lock Axis Values?

Double click on the axis, go to the Scale tab, enter the values you want,
and clear the checkboxes.

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


"ryan" wrote in message
...
I want to show a progression of data, tracking towards reaching a
predetermined goal. Unfortunately, as I get closer to the desired goal,
my Y
axis values are changing every time I update the data, thereby making it
look
like I am not getting any closer to the desired goal.

Is it possible to lock in the Axis values, so that they do no autmatically
adjust to "fit" the data provided. Thx.



  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 124
Default Lock Axis Values?

Thank you.

"Jon Peltier" wrote:

Double click on the axis, go to the Scale tab, enter the values you want,
and clear the checkboxes.

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


"ryan" wrote in message
...
I want to show a progression of data, tracking towards reaching a
predetermined goal. Unfortunately, as I get closer to the desired goal,
my Y
axis values are changing every time I update the data, thereby making it
look
like I am not getting any closer to the desired goal.

Is it possible to lock in the Axis values, so that they do no autmatically
adjust to "fit" the data provided. Thx.




  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,344
Default Lock Axis Values?

Isn't that life? The harder you work the farther you get from your goal.
(Reminds me of Alice through the looking glass).
--
Thanks,
Shane Devenshire


"ryan" wrote:

Thank you.

"Jon Peltier" wrote:

Double click on the axis, go to the Scale tab, enter the values you want,
and clear the checkboxes.

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


"ryan" wrote in message
...
I want to show a progression of data, tracking towards reaching a
predetermined goal. Unfortunately, as I get closer to the desired goal,
my Y
axis values are changing every time I update the data, thereby making it
look
like I am not getting any closer to the desired goal.

Is it possible to lock in the Axis values, so that they do no autmatically
adjust to "fit" the data provided. Thx.




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
How do I split a y axis in order to display extreme values? KGB Charts and Charting in Excel 1 November 17th 06 04:27 PM
Excel Charts X Axis values as dd/mm/yy hh:mm PeterS Charts and Charting in Excel 1 May 30th 06 03:09 PM
Y Axis values on bar charts mr_teacher Charts and Charting in Excel 1 May 12th 06 10:34 AM
values in Y axis changes to percentage maztaz Charts and Charting in Excel 2 April 22nd 06 10:14 PM
Y Axis is repeating values - can't figure out why fuzzyfreak Excel Discussion (Misc queries) 2 March 7th 06 12:50 PM


All times are GMT +1. The time now is 12:18 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"