LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Geema
 
Posts: n/a
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart values from several worksheets Mike Charts and Charting in Excel 4 March 31st 05 03:07 PM
How do I reference values from 200 worksheets onto a summary sheet mac849 Excel Discussion (Misc queries) 4 March 17th 05 09:26 AM
Footer values on multiple worksheets Tracy Excel Discussion (Misc queries) 0 February 22nd 05 07:59 PM
How to sum values in multiple worksheets Robert Lawrence Excel Worksheet Functions 3 January 29th 05 05:15 AM
How do I sum values from different worksheets within one workbook. master gardener Excel Worksheet Functions 1 January 28th 05 07:19 PM


All times are GMT +1. The time now is 05:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"