Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Charting information from a number of worksheets
Dear All
I have a spreadsheet set up with one worksheet for each week of the year. The spreadsheets all have exactly the same template. I would like to plot a graph of the data held in cell B4 in all of the worksheets. I want to end up with a graph with the weeks across the bottom and the value of B4 for each week on the y axis. Is this possible? Thanks Ian |
#2
|
|||
|
|||
While searching for the answer to my own question - I found this - which may
be helpful for your issue. http://www.peltiertech.com/Excel/Cha...iffSheets.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Charting My Data -- | Charts and Charting in Excel | |||
How do I combine two worksheets into one graph | Charts and Charting in Excel | |||
Charting time? help please... | Charts and Charting in Excel |