Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Everyday a new line of data is appended in a Excel file, and there is a chart illustrating the data. The chart data range is like ='Sheet1'!$H$2:$I$8, and after appending a new line to the Excel file, I have to manually modify the data source to ='Sheet1'!$H$2:$I$9, is there any simpler way of doing this, i.e, to make chart data source expand automatically when new data is append?

BTW, I'm using Excel 2007.

share|improve this question

1 Answer 1

up vote 3 down vote accepted

Format your data table into an Excel Table. Do this by highlighting the data range and tapping Ctrl+T. Or go to the insert menu and click table.

That should be enough. When you add rows to the bottom of the table, the table size will increase automagically in Excel 2007. The graph will update the range automatically, too, if the graph's range matches the table. If not, you may need to go into the graph and re-select the data range to match the table.

share|improve this answer
    
It works. Many thanks. –  ZelluX Feb 2 '10 at 5:39

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.