View Full Version : Excel charts

21-05-2002, 02:37 PM
Is there a way to select data from more than one sheet for a chart without creating a summary sheet which refernces the desired data?
I have just one figure on each sheet which I want to use as source data.

21-05-2002, 03:23 PM
Right Click your chart, select Source Data, select the Series tab then select Add. Click the Values entry box selector and then click on the worksheet tab where your new data is and hilite the data with the mouse. Click the values selector again and click OK on the Source Data window.
The chart should now be updated.

22-05-2002, 12:16 AM
Russell - Thanks for the help!