If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Graph with data from multiple sheets
Hi.
I have a worksheet with 12 identical sheets (with different data of course...) for each month. I need to draw a graph where i take the data from the same field in all 12 sheets as the data for the graph - but how do you do that exactly? Is there a clever way to do this? /Anders |
#2
|
|||
|
|||
Graph with data from multiple sheets
Anders -
See my example he http://peltiertech.com/Excel/ChartsH...entSheets.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ Anders Bystrup wrote: Hi. I have a worksheet with 12 identical sheets (with different data of course...) for each month. I need to draw a graph where i take the data from the same field in all 12 sheets as the data for the graph - but how do you do that exactly? Is there a clever way to do this? /Anders |
Thread Tools | |
Display Modes | |
|
|