I have a simple chart that shows actual expenses with a line and budget with an area chart. I like the data to show up on the tick marks, so that it takes up the entire horizontal plot area.
When I add a secondary axis, the left side of the line and area charts stay on the tick marks, but the right side pulls off of the tick marks, leaving an unsightly gap. I have tried re-formatting the x-axis, but it doesn't help. If I remove the new series of data, the chart goes back to how I wanted it.
How can I get my charts to be flush on the right side again, with the secondary axis???
Bookmarks