Excel: One chart from same range on two sheets

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.
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
dougf1rConnect With a Mentor Commented:
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
 
Patrick MatthewsCommented:
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
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.