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

How to chart 3 variables against a common axis?

Experts:

I'm having trouble charting 3 lines of data to the same y axis.  See attached example.  

The chart seems to be summing the data??  What am I doing wrong?

Help?
Gary
FPS-09-2011-EE.xls
0
garyrobbins
Asked:
garyrobbins
  • 2
2 Solutions
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

you're using a stacked line chart. Change the chart type to an unstacked line chart (one symbol to the left).

cheers, teylyn
0
 
JacobfwCommented:
You are using a "Stacked Line with Markers" but you need to have a "Line with Markers" chart type.
Right click on a line and select "Change a series Chart", and select the correct chart type.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
0
 
garyrobbinsAuthor Commented:
THANK YOU!  I appreciate the prompt responses.  That's ;one reason I love EE.

Hope you find my point assignment agreeable.

Gary
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

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