Step 6: Add the suitable title and axis labels so the final chart will beĮxample: Sale of vennila flavor on store 1 is 45 units and store 2 is 80 units. So the resultant chart will give you scatter plot with Labels of flavors and Label of X values and Y values (x, y coordinates) as shown below Click on X Value and Y Value under LABEL OPTIONS. Step 5: Now the ice cream flavors will appear on the labels. ![]() Step 4: A POP up will open and select the data label range, in our case from A2: A7 and click ok as shown below Under LABEL OPTIONS select Value From Cells as shown below. Now right click on the label and click format data labels. Step 3: Now we need to add the flavor names to the label. ![]() Step 2: Click the + symbol and add data labels by clicking it as shown below ![]() Step 1: Select the Data, INSERT -> Recommended Charts -> Scatter chart (3 rd chart will be scatter chart) In this tutorial we will learn how to add a custom label to scatter plot in excel.Below we have explained how to add custom labels to x-y scatter plot in Excel.ĭata used: Sale of Different flavors of ice cream on Store 1 and Store 2. Combination chart or most commonly known as combo chart in excel is a combination of two or more than two different charts in excel, to make such types of combo charts we can use the option of creating a combo chart from the insert menu in the chart tab also in order to combine two charts we must have two different data sets but one common field to combine.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |