need 2 lines on 1 axis

[superchew]

Weekly Leadership Report.xlsm


How do i get the Actual goal and stretch goal on the same axix. Please help.

[gmr4evr1]

You mean like this?

need-2-lines-on-1-axis-weekly-leadership-report.xlsm

[superchew]

i need it to be accurate. Currently it looks like it 10 when its actually six. I can't figure out how to make it right.

[gmr4evr1]

WOW, I didn't notice it was doing that, and I don't know why it is plotting it that way

[MrShorty]

gmr4ever1, you added the 2nd "line" series as a stacked line (which plots the 2nd series 6 units above the 1st line) rather than a regular line. I suspect this issue will resolve itself if you change the chart type of the stretch goal line to a regular line rather than stacked line.

[gmr4evr1]

HA! Thanks once again MrShorty, I didnt even notice I had done that. Here you go Superchew...
need-2-lines-on-1-axis-weekly-leadership-report.xlsm