MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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

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


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!!!