Combo chart - Primary axis data changes when series chart type is changed

Question

I am trying to create a combo chart in excel with some data sharing the same primary axis.

When the data is displayed as a combo of bar and line the primary horizontal axis labels/data is correct.

However when I want to change the bar data series to a x/y scatter plot the primary axis changes to a default 1,2,3,4,5,6,7,8 which I then cannot change.

I saw a similar post where someone had the same issue and it was rectified by changing the series formula for the graph, however I have tried that with no such luck.

Any help would be much appreciated. If useful I can share the data in a onedrive file.

Kind regards

Answer 1

Hi Richard,

For further assistance regarding this concern, we suggest posting this query to our Tech Community forum. We have experts that can provide you the most appropriate resolution that would help you with Excel.

If you have other questions or concerns in the future, we're just a click away.