Line missing from chart

Hi Folks! I am attaching a PPT file that should haved two lines plotted in the graph which can clearly be seen when selecting Edit Data. Can someone tell me why only one line is plotted there? Thanks!
graph-issue.pptx
mrosierAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Karen FalandaysConnect With a Mentor Training SpecialistCommented:
It has to do with the chart type. Change it to a line or a line with markers and all is well.
kfalandays
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

change the chart type to a "Line with Markers" instead of "Stacked Line with Markers".

In your file, the chart type is "Stacked Line with Markers", which does not work when values for a particular X value don't stack up.

With  "Line with Markers" chart you can see that the two data lines cross.

This scenario cannot be depicted in a stacked line chart. Therefore, the second series will not show in a stacked line chart.
0
 
mrosierAuthor Commented:
Thanks for the feedback folks! We are a little unfamiliar on how to make this sort of change though from Stacked Line to just Line. Can you provide some details as to where those configs can be made?
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Karen FalandaysTraining SpecialistCommented:
simply click on the chart. From the CHart tools tab, select the Design tab, and then click the Chart type button. In the  line category are several sub types to select from. Let me know if you cannot find that and I will make the change for you
kfalandays
0
 
mrosierAuthor Commented:
ahhh ok, I see what you are saying. I was looking for something explicitly labeled as line or stacked line in the settings. I see the chart typ info there though. Thanks for the feedback kfalandays!
0
 
Karen FalandaysTraining SpecialistCommented:
Glad to be of assistance!
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.