Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Multiple Ranges for a Chart
I am trying to use ranges from several pages in one chart. When I set the
source data to: =Sheet1!$A$2:$O$2+Sheet2!$A$3:$K$3 I get the following error: Reference is not valid HELP, what am I doing wrong? |
#2
|
|||
|
|||
Each x- or y- range for each series must be from a single worksheet.
You can combine different sheets for different sheets or different ranges for x- and y- ranges for a single series but not multiple worksheet ranges in a single x- or y- range. Consider consolidating the data into a single worksheet and then plotting that consolidated range. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I am trying to use ranges from several pages in one chart. When I set the source data to: =Sheet1!$A$2:$O$2+Sheet2!$A$3:$K$3 I get the following error: Reference is not valid HELP, what am I doing wrong? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I display multiple series in a pie chart? | Charts and Charting in Excel | |||
Creating a High-Low-Close chart with multiple series? | Charts and Charting in Excel | |||
Multiple Ranges for a Chart | Charts and Charting in Excel | |||
Sorting Multiple Ranges | Excel Worksheet Functions | |||
compare unique identifiers in multiple ranges | Charts and Charting in Excel |