Xy Scatter Chart. Select Series A from the drop down on top left. XY charts show the relatedness of two sets of data.
In the scatter chart we can see that both horizontal and vertical axes indicated numeric values that plot numeric data in excel. I want the condition to be if the XY coordinates are in a certain rank 1-5 they will be colored according to their rank. However Excel added data to the x-axis that isnt there at all - starting from 0 and ending on 4 instead of 15 to 35 as the x-data clearly contains.
That is when x variable increases y variable tends to decrease but the graph does not form an exact straight line.
You can use the XY scatter chart to plot between two and four variables X Y size colour from one of your data sources. Choose an XY chart for the following example tasks. I dont want the condition of XY XY XY. I then inserted a scatter chart based on columns FG.
