SOLVED

Need Assistance in Line Chart

New Contributor

I'm trying to create a line chart based on a specific data set. However the lines aren't plotting correctly. For example when I enter 1 for the month January the line is placed correctly but when I try putting 3 for the month of February it stays the same and is being plotted same as the month of January.

4 Replies

@anjelobobis11 

Could you create a small sample workbook demonstrating the problem, and make it available through OneDrive, Google Drive or another cloud service?

best response confirmed by anjelobobis11 (New Contributor)
Solution

@anjelobobis11 

It looks like your chart is a 100% Stacked Line chart, so the values for January to March are 100% = 1.

Change the chart type to Line.

S1275.png

Thank you so much for this, it worked!!