• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 352
  • Last Modified:

Excel: One chart from same range on two sheets


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 Brown
Murray Brown
1 Solution
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?
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.
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
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.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now