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

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