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

Chart Y Axis

Posted by Aaron on December 26, 2001 6:33 AM
I am trying to get my chart to change the Y Axis automatically when the data is changed. For instance: If I have 10 periods of data for my X Axis, and my Y Axis ranges from 10 to 100, I would like for my Y Axis range to also range from 10 to 100. I really need help, and I know I didn't ask a very clear question, but if anyone could help I would greatly appreciate it. thx

Re: Chart Y Axis

Posted by Aaron on December 26, 2001 7:47 AM

I am trying to get my chart to change the Y Axis automatically when the data is changed. For instance: If I have 10 periods of data for my X Axis, and my Y Axis ranges from 10 to 100, I would like for my Y Axis range to also range from 10 to 100. I really need help, and I know I didn't ask a very clear question, but if anyone could help I would greatly appreciate it. thx

Also if my Y Axis Data Chages from 100 to 100K I would like for my chart to change. Thanks again


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.