Auto Expanding Chart Series
In earlier versions of MS Excel, it was difficult to create a chart that expands when data is added to the end of one or more of the series. Follow these steps:
- First, open a spreadsheet with data for a chart.
- To designate a data area as a list, click in a cell in the soon-to-be list.
- Then choose Data, List, Create List.
- Then create the chart using the list data.
When you add data to the List, the chart will expand automically.
Tip is by Helen Bradley, from PC Magazine 4 May 2004.
Just click on the button for the Tiproom's Home Page.
Date of last revision: 20 January 2006.