I have a data set that looks like the table shown on the left. The data has 3 columns, ranked by values in column 3; column 1 is the index of the row in the ranking; column 2 is the 'category' assigned to that row.
I am not sure if this is a 'single series' or 'two data series' problem... but I would like to draw a chart where, each value in column 3 is shown as a point on the chart referenced to the left Y-axis, but the shape of that point should be determined based on the label next to that value, in column 2.
Can I do this using scatter point chart/point-only-line chart? I tried to do this but it plots all points on the chart with the same shape, I am not sure how to use column 2 to change the shape of the points..
I would be grateful for any advice!
I followed bandersnatch's 2nd suggestion and have got quite close to it but I still have some problems. Testing on the dummy data it works perfectly. but when working on the real data, it appears that those empty cells are considered as a '0' value and as you can see on this screenshot below, these are plotted as well and making an incorrect chart:
I am not sure how to fix this? I already made sure that empty cells are shown as 'gap', see screenshot below. I have shared my data file for anybody interested to play with, at: https://drive.google.com/file/d/1L32urXmkYoA0WZDSXTuBS_UMM3a__bMn/view?usp=sharing