Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Chart values from several worksheets | Charts and Charting in Excel | |||
How do I reference values from 200 worksheets onto a summary sheet | Excel Discussion (Misc queries) | |||
Footer values on multiple worksheets | Excel Discussion (Misc queries) | |||
How to sum values in multiple worksheets | Excel Worksheet Functions | |||
How do I sum values from different worksheets within one workbook. | Excel Worksheet Functions |