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 will not update range of x-axis as new data is entered.

Posted by Craig Oechsle on September 22, 2000 2:16 PM

I have "written" a spreadsheet to calculate SPC numbers for the manufacturing engineers in our plant. The program graphs data as it is entered by the operators. I would like for the x-axis range to automatically update itself as new data is entered. I am exhausted from my efforts in trying to resolve this issue. Help. Thanks, Craig Oechsle

Re: Chart will not update range of x-axis as new data is entered.

Posted by Marcus Lyngcoln on October 11, 2000 9:45 PM

Craig,

I too am looking for this solution. My data range(series) must be extended by ONE column each month and I am thinking that perhaps a macro would be the only way to automate this. Hope for your sake and mine that someone has solved this problem!!!

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.