Add values to a series in a chart
 

How do I add other values to the same series on a chart. The other values are
on seperate worksheets.
Example: this is what I have =Sheet1!$B$34 and I want to also add to this
series =Sheet2!$B$3.
I have tried =Sheet1!$B$34 and Sheet2!$B$3 but get an error.

Add values to a series in a chart
 

Hi,

Have a read of Jon's information on charting from different sheets.
http://peltiertech.com/Excel/ChartsH...iffSheets.html

Cheers
Andy

Marty wrote:
How do I add other values to the same series on a chart. The other values are
on seperate worksheets.
Example: this is what I have =Sheet1!$B$34 and I want to also add to this
series =Sheet2!$B$3.
I have tried =Sheet1!$B$34 and Sheet2!$B$3 but get an error.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info