How to Add an Axis Title to an Excel Chart. By: Aaron Parson. Share; Share on Facebook; When you insert a chart in Excel, the program might automatically display a chart title or a legend. In cases where Excel omits these labels or they don't adequately explain the chart, turn on axis titles in Excel 2013's Chart Elements menu or the Layout tab. A Bubble chart in excel is a visual representation of the relationship of data objects in 3 numeric-data dimensions: The X-axis data, the Y-axis data, and data represented by the Bubble size. Out of those three data sets used to make the Bubble chart, a Bubble chart in excel shows two axes of the.
When you create a bubble chart in Excel, you do not select the labels, as Excel would not know what to do with them. Instead, you need to add the chart labels after you create the chart.
Adding the x-axis and y-axis labels can be done in the usual way. However, Excel has no specific tools for adding individual data labels to each bubble. You will need to add each data label separately. For example, say you have just created the following bubble chart from the range B2:D7. Follow these steps to add the employee names as data labels to the chart:. Right-click the data series and select Add Data Labels. Right-click one of the labels and select Format Data Labels.
Select Y Value and Center. Move any labels that overlap.
Select the data labels and then click once on the label in the first bubble on the left. Type = in the Formula bar. (A7 is the name of the employee whose current Salary is represented by the bubble.). Press Enter. Repeat Steps 5 through 8 to add the name of the employee whose salary is represented by the bubble.
![Mac Mac](/uploads/1/2/5/5/125591081/529311131.jpg)
Microsoft Excel charts include legends by default. You can delete the legend or change the settings so that it isn't inserted when the chart is created, but doing so can make the chart difficult for others to read, especially if it contains many data points. If you decide that you need a legend after all, you can manually add one to your Excel chart. The Mac version of Excel has the same options for creating and editing a legend as the Windows version does, but the process for adding the legend is different.