Please help! Spreadsheet to Area Chart Question

[msworkingwoman]

Converting data from an excel spreadsheet to an aea chart. The chart looks weird compared to the data we have. We have data for three shifts. Our data indicates the second shift has the highest volume but the data looks like the 3rd column has the highest. Is there something special I should be doing? On the X axis the highest value is way higher than anything in our data. Any thoughts?

I am preparing this for a job interview and I need to figure it out. I'm so grateful for any help.

Thanks!!

 

[tusharm]

My guess is that you created a stacked area chart. Instead, use the 1st sub-type in the Area chart types.

 

[msworkingwoman]

Thank you so much for your response! I think you are right but have one small issue now. When I do the first chart I dont see the series 1 data although I see Series 1 and its color in the legend. Any thoughts on that! Please know how grateful I am for your input.

Thanks!

 

[tusharm]

It's getting covered by the other 2 series.

Thank you so much for your response! I think you are right but have one small issue now. When I do the first chart I dont see the series 1 data although I see Series 1 and its color in the legend. Any thoughts on that! Please know how grateful I am for your input.

Thanks!

 

[msworkingwoman]

Is there anyway to remedy that or is the just the way it is and those who view should assume as such?

Thanks!

 

[tusharm]

Use a Line chart rather than an Area chart?

Is there anyway to remedy that or is the just the way it is and those who view should assume as such?

Thanks!

 

[msworkingwoman]

Perfect thanks so much!!!