I am not sure how to fix this? I already made sure that empty cells are shown as 'gap', see screenshot below.
Finally, you will double click 'Blank workbook. If you have successfully double clicked the icon, your screen should look like Figure 2. A picture of the Microsoft Excel icon is provided in Figure 1. 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: You will start by double clicking the Microsoft Excel icon that is found on the computers desktop. Testing on the dummy data it works perfectly. checked, meaning the coordinates of each point appear next to the point. I followed bandersnatch's 2nd suggestion and have got quite close to it but I still have some problems. 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.Ĭan 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. Click the My Apps button and click the See All button to view ChartExpo, among other add-ins.
Open the worksheet and click the Insert button to access the My Apps option. I am not sure if this is a 'single series' or 'two data series' problem. To get started with the Scatter Plot in Excel, follow the steps below: Open your Excel desktop application. 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 have a data set that looks like the table shown on the left.