Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I need data from many sheet into one chart (In its own sheet).
I know how to do it when its from from sheet (In this example, sheet named Pernille) : =Pernille!$AS$10 I tried this : =Pernille!$AS$10;Aase!$AS$10 But the reference was not valid. Please help, I havent been able to find anything, not even in my E-learning. |
#2
![]() |
|||
|
|||
![]()
Martin,
Probably the easiest way to chart data from multiple sheets is to create a summary range in a single sheet that references the other sheets with formulas. If you use this technique then all you have to do is generate the chart using the summary range as your source. ---- Regards, John Mansfield http://www.pdbook.com "Martin Thorgaard" wrote: I need data from many sheet into one chart (In its own sheet). I know how to do it when its from from sheet (In this example, sheet named Pernille) : =Pernille!$AS$10 I tried this : =Pernille!$AS$10;Aase!$AS$10 But the reference was not valid. Please help, I havent been able to find anything, not even in my E-learning. |
#3
![]() |
|||
|
|||
![]()
hehe, thx....of course.....
Have a nice day "John Mansfield" skrev: Martin, Probably the easiest way to chart data from multiple sheets is to create a summary range in a single sheet that references the other sheets with formulas. If you use this technique then all you have to do is generate the chart using the summary range as your source. ---- Regards, John Mansfield http://www.pdbook.com "Martin Thorgaard" wrote: I need data from many sheet into one chart (In its own sheet). I know how to do it when its from from sheet (In this example, sheet named Pernille) : =Pernille!$AS$10 I tried this : =Pernille!$AS$10;Aase!$AS$10 But the reference was not valid. Please help, I havent been able to find anything, not even in my E-learning. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
changing proportion of chart and data table | Charts and Charting in Excel | |||
Help! I'm losing one series of data in an overlay chart. | Charts and Charting in Excel | |||
One data series and two y-axes in an Excel chart? | Charts and Charting in Excel | |||
multiple or changing colours in a data table on an excel chart fo. | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |