MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to restrict only a certain range of data to show on charts?

Posted by -------------------------------------------Ian on September 27, 2001 6:15 PM

I have a range of data to be shown on charts, and the no. of rows i have for the range is 600 rows, everytime the data exceed the 600 rows I would have to delete the older data and paste the recent data to the first few rows, and the chart allows only 600 range of data, I want the chart to show only the recent 500 range of data, and the data table can be filled for more than 600 rows, how can I do this? Thanks for your time.

Posted by Aladin Akyurek on September 29, 2001 3:19 AM

See: 32370.html. (NT)