?
Solved

Graph question

Posted on 2014-11-17
3
Medium Priority
?
137 Views
Last Modified: 2014-11-17
Hi,

My attached graph is behaving strangely

My ASP line (Blue) is correctly mapping to percentage points on the vertical axis, but my EU (Red) and NA (Green) line are completely off, can someone explain why?

Thanks
EE.xlsx
0
Comment
Question by:Seamus2626
  • 2
3 Comments
 
LVL 24

Expert Comment

by:Phillip Burton
ID: 40447330
It's because you are using a stacked line. That's why the green line is consistently at 100%.
0
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 2000 total points
ID: 40447334
If you change the Chart Type from "Stacked Line with Markers" to "Line with Markers", you will find it more to your liking. (See attached.)
EE141117.xlsx
0
 

Author Closing Comment

by:Seamus2626
ID: 40447350
Thanks!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

Question has a verified solution.

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

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

608 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question