How to make scatter plot chart of data with labels in horizontal axis?
I have Two columns of data in my excel file, which one of is in text format(see the excel attachment column A and column B.) I want to have a scatter plot of this data without restructuring it. (a chart like “chart b”). Can you guide me on this issue? I have searched the internet for this issue, but the way I found (making a stacked line chart and removing its line and ending up with a chart like chart B) don’t meet my expectation. ( I want to have a chart the data that have the same" X Axis value", lie above each other vertically.)

Attached Files

scatterplot.xlsx (29.8 KB, 1 views)

Quite difficult to set up, but a lot easier then setting up multiple series and you need do nothing to add new values except add/remove/change the table. You only need to change columns A and B, columns C and D calculate for themselves and the table adjusts its own size, and the plot changes automatically too adding/removing categories as needed.
There are 2 series:
1. For your data
2. For labels (a single point for each x value (category) at 0 y, with only data labels showing)
Both series are true x-y scatter plots, not line charts.

Attached Files

msofficeforums51971scatterplot.xlsx (31.3 KB, 2 views)

Thank you very much. Your reply solved the problem.