Stacked area chart with XY scatter error bars

[Johnny C]

Hi

I've been populating a bunch of charts. They're stacked areas, the total is done as an XY scatter with a negative 100% error bar to get a dotted line down to the the X-axis. There's a lot of them, about 30. They have all worked fine.

All of a sudden, 1 chart is being a pain. it won't scale the secondary horizontal axis, it's adding extra places on the axis so it won't line up with the stacked areas below, it's wider than the stacked areas. If I manually change the min/max items on the axis to match the primary horizontal axis it goes too small.

I can't remove the secondary axis because the XY refuses to work without it.

I took one of the other charts that works, they have the same number of series, and copy & pasted all the series formula from one to the other and it squashes all the areas to a dot on the bottom left and the XY to a dot on the top right.

What's going on?

I can't post an image because my work internet blocks file sharing sites.

 

[Johnny C]

Ignore, I found I coulad add error bars to a line. Works fine.