Line and Clustered Column - How to get the Column Axis scale and line scale to be the same increment

[ap]

How would I get the line and column to share the same values?

Even though the Net Revenue is 49 million, the Previous year is 57 million, because of it not sharing the same values, visually it looks like the Net Revenue is exceeding the previous year target.

[Sean · Accepted solution]

@ap
Go to the formatting (paint brush) options for the chart
You may have to scroll down within the Y-Axis options to find the Secondary Y-Axis options
Then either turn the secondary off completely or enter start and end values for it
Good Luck! 🙂

[ap]

you are the man, thank you so much!!!!!