Source Data from Multiple Worksheets

D

Don retired

My chart is a XY scatter chart. I am trying to plot my
weight vs. time. Then data is from several worksheets,
each is a worksheet with my exercise history on it. Does
EXCEL allow this? I can't get it to work.

I know I could move these to one sheet, but I'm trying to
avoid this.

Thanks,
Don
 
J

Jon Peltier

Don -

You either must move the data to one sheet, or plot each sheet's data as
a separate series.

- Jon
 

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

how to copy XY charts into new worksheet? 1
Data points in chart incorrect 0
Embed the same Excel multiple times 0
XY scatter plot with more than 32000 rows in Excel 2003 0
Average bar charts with individual data points 2
Employee Schedule not plotting properly - chart type / data series not correct 0
Creating a Chart on form from selected data in query. 0
How do I disable automatic chart creation in Excel? 1

Top