Making a chart with Multiple Sheets

**irishpaim** · 11-30-2010, 04:24 PM

Hi guys, I'm sure you get this question a lot, but everything I've looked at isn't helping. I've searched the forums, google, etc. Nothing.

So basically I have five sheets of different sets of data. I need to create a smooth line of each x vs. y set in one chart. The x values are located in column B and the y values in column C for every sheet. The range for the x values is from -5 to +5 for all sheets, but with different scales on each so there are different number of rows.

So now I have all five series set up correctly with all of their values selected. But I can't get the "Chart data range" set up right. And therefore it doesn't display right. I tried making it this, but it didn't work:

Please Login or Register  to view this content.

That would have all the values selected on each sheet. How do I correctly format that to get my chart to work?

Thanks.

**irishpaim** · 11-30-2010, 09:42 PM

Damn, no one has any idea?

**SDruley** · 11-30-2010, 10:19 PM

Would recommend an example workbook.

**irishpaim** · 11-30-2010, 10:49 PM

Originally Posted by SDruley

Would recommend an example workbook.

Huh? Should I post my file?

**Andy Pope** · 12-01-2010, 05:39 AM

Why do you not consolidate the chart data into a single worksheet?

It's not clear whether you want 1 line in the chart or multiple lines.

If multiple lines then you can use the select data to define each series x and y values.

You can also use the select data to create a single series from multiple sheets. But be aware that the series formula has a finite length, 1024 characters.