Hi all,
I'm trying to create a simple line chart showing gross sales by month versus gross margin by month. I can't stop Excel from ADDING one line to the other. I want to show 2 separate lines without combining them.
Thanks,
Michelle
Hi all,
I'm trying to create a simple line chart showing gross sales by month versus gross margin by month. I can't stop Excel from ADDING one line to the other. I want to show 2 separate lines without combining them.
Thanks,
Michelle
It's a stacked line chart as it sits. Select the chart, Chart Tools > Design >
Change Chart Type, Line, Line w/ Markers
or,
Change Chart Type, X-Y Scatter, Scatter w/ Straight Lines & Markers
Entia non sunt multiplicanda sine necessitate
That fixed the data lines - Thanks! Now the y axis labels are not correct. It should show the date - 01/31/18 - but the dates seem random.
You need to decide whether you want a true data axis or a simple category one.
To only show labels for the dates you have, with equal spacing between categories, set the axis to be Text rather than Automatic or Date.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks