![]() If Left(TypeName(Selection), 5) "Chart" Then It opens a code module where you need to paste the code below.Now, go to the Insert tab and select Module. ![]() At this point, the Microsoft Visual Basic for Applications window opens.Then, select View Code from the options.At first, right-click on the Sheet Name (VBA).Applying VBA Code to Add Data Labels to Scatter Plot in ExcelĪnother alternative to solve the problem is to apply the VBA code to run a Macro. Read More: How to Make a Scatter Plot in Excel with Two Sets of Data (in Easy Steps)Ģ. With the data range, our Scatter Plot with data labels looks like the one below.Finally, our data labels are clearly perceivable from one another.Under the Shadow category, select the shadow as the image below from the Presets.At this moment, it is more visible than before.It also opens the Format Data Label task pane.So, click on the data label James two times to select this label only.But, from the image above, we can clearly notice that the data labels of Susan and James look partially unified.Finally, our Scatter Plot with data labels looks like the one below.Later, uncheck the box of Y Value in the Label Options.These cells contain the Name of the individuals which we’ll use as our data labels. Then, select the cells in the B5:B14 range in the Select Data Label Range box.In the Label Options, check the box of Value From Cells.Firstly, click on the Label Options icon.By our previous action, a task pane named Format Data Labels opens.After that, click on More Data Label Options from the choices.From the drop-down list, select Data Labels.Now, select Add Chart Element from the ribbon.At this moment, we can see the Scatter Plot visualizing our data table.After that, select Insert Scatter(X, Y) or Bubble Chart > Scatter.The first one is for the Name and the second one is for the Weight (lbs). There are 2 columns in this selected range of cells. At first, select cells in the B4:C14 range.But, before adding the data labels, we have to make the chart from our data table. In our first method, we’ll manually add data labels to the Scatter Plot using the Chart Elements option in Excel. Using Chart Elements Options to Add Data Labels to Scatter Chart in Excel Without any further delay, let’s get into the methods to do it.ġ. Also, we want to add data labels to the chart to make it more understandable. ![]() We wanna plot the Weight according to the Name of the individual in a Scatter Plot. Suppose, we have a Weight List of some individuals. In this article, we’ll show you how to add data labels to a Scatter Plot in Excel with 2 different methods. ![]() 2 Methods to Add Data Labels to Scatter Plot in ExcelĪdding data labels to a Scatter Plot includes some easy steps. ![]()
0 Comments
Leave a Reply. |