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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top