Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Chart values from several worksheets
I have several worksheets that have a value located in the same cell on each
worksheet. I would like to graph these values. Each worksheet is a monthly summary of activity for an event. Each worksheet includes simple average and sum calculations, and it is the value of the sum on each worksheet that I want to graph. To complicate this, I would liek to set it up so tht I can insert a new worksheet into the set and have it's number automatcially added to the graph. I've looked at ranges and it looks promising, but everythimg I try to define a graph data source I get an error that says something like "Reference is not valid" The data range I am attempting to use is: ='1:3'!$E$41 Any suggestions or comments about what I am doing wrong? -Michael |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero values in a log chart | Charts and Charting in Excel | |||
How do I reference values from 200 worksheets onto a summary sheet | Excel Discussion (Misc queries) | |||
How to sum values in multiple worksheets | Excel Worksheet Functions | |||
Missing values in Excel Line Chart | Charts and Charting in Excel | |||
linked values in a chart | Charts and Charting in Excel |