Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

Back to Charting for Excel archive index
Back to archive home

CHANGING AXES ON A GRAPH

Posted by Dana on July 16, 2001 11:34 AM

I believe this is a REALLY simple question, so hopefully someone will set me straight! I have a graph with changing values in it. I have a pulldown menu that changes what the graph is showing with the data set underneath. I DO NOT want the minimum value on the axis to be set at zero, but I also don't want to go in and change it everytime I change what I'm graphing. Does anyone know the answer??

Re: CHANGING AXES ON A GRAPH

Posted by Skewer on July 16, 2001 5:48 PM

I think this will work:

Select the value axis on your chart, then click the
format button to the right of Value Axis on the chart
toolbar. On the Scale tab you can un-automate the
scale min/max which should do what you want.

If not, hell I dunno :)

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.