Importing data from several sheets, to one chart

  • Thread starter Martin Thorgaard
  • Start date
M

Martin Thorgaard

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.
 
J

John Mansfield

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
One Chart, Same Data ranges, different source sheets 4
Adding data to MS Access from csv file 0
One extra x axis item that wont go away - can anyone help? 3
External cell reference between two excel worksheets both in One Drive 0
Possible? Variable X and Y data sources and Auto Charting 0
copy chart between multiple sheets in workbook 4
how to copy sheet with charts without link to original data 6

Top