Excel 2010 chart line graph dilemma

How do I combine multiple scatter charts? I have two "sales-to-cost savings" scatter charts; one showing desired outcomes and another showing actual outcomes. I want to create a single scatter chart that shows both outcomes, kinda like an overlay (see below), so that sales people can see where they are at and where they need to go. I am looking for a solution that accomplishes this desired look. Please, don't suggest alternate layouts or other ways to display data. I need all the data and plot points to apear in one chart.

 Not Pretty but sorta what I need the chart to do...
Who is Participating?
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:

create the XY chart for the first dataset. Then add the second dataset as an additional series.

Right click the chart and then "Select Data", click Add and select the cells for the X and the Y axis manually.

See attached.

cheers, teylyn
primeradminAuthor Commented:
The instruction from teylyn put me in the right direction and I was also able to configure a complete data set to show both sales and savings on the chart. Thx.
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.