Solved

# Excel: One chart from same range on two sheets

Posted on 2013-06-12
Medium Priority
348 Views
Hi

I have two sheets in a spreadsheet containing data in range A2:G10. How do I generate one graph that has two lines: one for each set of data.
0
Question by:Murray Brown

LVL 93

Expert Comment

ID: 39241968
A sample file would be helpful.

Also, your range on each worksheet is A2:G10, yet you say that results in one line per worksheet.  What range are you actually trying to plot?
0

LVL 1

Accepted Solution

dougf1r earned 2000 total points
ID: 39242115
The solution depends on the chart type. However, adding two series from different sheets can be generally described as:

1) Right click on the chart
2) Click Select Data...
3) Click "Add" under Legend Entries (Series)
4) Navigate to one of the sheets and select the data for the chart
5) Repeat steps 3 and 4 for the second set of data

Hope this helps.
0

Author Closing Comment

ID: 39244100
Thanks very much
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
###### Suggested Courses
Course of the Month16 days, 23 hours left to enroll