Hi,

I have a chart that previously used a column chart and line chart, both these shared the x axis but had the line had a second y axis.

Now I need to add a few lines (one of which is a vertical one, the other drawing between two random points on the line chart) so I changed the line chart to a scatter plot so I can have a bit more control.

However, they now have a second x axis as well as y! Is there any way to make a scatter plot and column chart share an x axis but have separate y axis?

Thanks

Joe