How can I add values from several worksheets in a line chart seri.
 

I have an Excel document with 12 (monthly) worksheets. I want to make a line
chart pulling data in one cell (same cell on each sheet) from each of the
twelve sheets. In other words, Jan F2 + Feb F2 + Mar F2, etc.

Can I do that on the chart's Source Data menu in the Series/VALUES field? If
so, what is the proper language/formula. If not, what are my options? Do I
have to make a total page and pull from it?

Also, is it possible to make the Category (X) axis label be the Worksheet
Name (Jan, Feb, Mar)

Lastly, is there a place that gives sample formulas for someone trying to
brush up on Excel skills?

Thanks! BN

I have a web page with information about charting data from different sheets. I
think you need to make a summary of the data. linked to the individual sheets, as
described in the page.

http://peltiertech.com/Excel/ChartsH...iffSheets.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Geema wrote:

I have an Excel document with 12 (monthly) worksheets. I want to make a line
chart pulling data in one cell (same cell on each sheet) from each of the
twelve sheets. In other words, Jan F2 + Feb F2 + Mar F2, etc.

Can I do that on the chart's Source Data menu in the Series/VALUES field? If
so, what is the proper language/formula. If not, what are my options? Do I
have to make a total page and pull from it?

Also, is it possible to make the Category (X) axis label be the Worksheet
Name (Jan, Feb, Mar)

Lastly, is there a place that gives sample formulas for someone trying to
brush up on Excel skills?

Thanks! BN