Note that you have to fill in all fields, for every point of the chart. Columns 4 and 5 are clearly not an elegant solution, and you’ll probably have to play with the values until you find what you want. If you don’t see the Add Chart Data button, make sure the chart is selected. Click the Add Chart Data button near the chart. Click a scatter chart or drag one to the sheet. Click the left and right arrows to see more styles.
Columns 1 and 2 contain the X and Y values for the scatter plot, column 3 the labels you want to add to each data point, column 4 and 5 are integers which represent the code for the marker symbol and color for the data point. Click in the toolbar, then click 2D or Interactive (there are no 3D scatter charts). To use it, you will need to enter the values for the chart in 5 columns, anywhere in the worksheet. The macro is pretty rough, but was sufficient for my needs as is, so I haven’t put extra efforts in: feel free to improve upon it… I cant change them to the corresponding numbers which is annoying. If I use the line chart instead of the scatter, the x-axis displays 'Untitled 1, Untitled 2' as the labels.
I dont want symbols, I just want a line connecting the points. I quickly coded a VBA macro to do that, with a sample workbook to illustrate the usage. So if I use a scatter plot, my axis turn out great, but I cannot adjust the lines width. You could think of this as plotting 5 dimensions at once, instead of the usual two.
In this tutorial, we are going to plot a simple column chart in Excel that will display. Recently, a client asked me if it was possible to create an Excel scatter plot of his products, adding a label on each data point, and using different colors and symbols for different types of products. To put the finish touches on the plot (the graph and axes label. Excel ScatterPlot with labels, colors and markers