Change the format of data labels in a chart - Microsoft Support
You can format the labels to show specific labels elements like, the percentages, series name, or category name. There are a lot of formatting options for data labels. You can use leader lines to connect the labels, change the shape of the label, and resize a data label.
Add or remove a secondary axis in a chart in Excel
You can quickly show a chart like this by changing your chart to a combo chart. Select a chart to open Chart Tools. Select Design > Change Chart Type. Select Combo > Cluster Column - Line on Secondary Axis. Select Secondary Axis for the data series you want to show. Select the drop-down arrow and choose Line. Select OK.
Add or remove titles in a chart - Microsoft Support
Add or remove titles in a chart. To make a chart easier to understand, you can add chart title and axis titles, to any type of chart. Axis titles are typically available for all axes that can be displayed in a chart, including depth (series) axes in 3-D charts.
Add a text box to a chart - Microsoft Support
Insert a text box on a chart. Click the chart to which you want to add a text box. On the Formattab, click Insert Shapes, and then click the Text Boxicon . In the chart, click where you want to start a corner of the text box, and then drag until the text box is the size that you want.
Add or remove data labels in a chart - Microsoft Support
Add data labels to a chart. Click the data series or chart. To label one data point, after clicking the series, click that data point. In the upper right corner, next to the chart, click Add Chart Element > Data Labels. To change the location, click the arrow, and choose an option.
Change axis labels in a chart - Microsoft Support
Right-click the category labels you want to change, and click Select Data. In the Horizontal (Category) Axis Labels box, click Edit. In the Axis label range box, enter the labels you want to use, separated by commas. For example, type Quarter 1,Quarter 2,Quarter 3,Quarter 4.
Move data labels - Microsoft Support
Move data labels. Applies To. If data labels you added to your chart are in the way of your data visualization—or you simply want to move them elsewhere—you can change their placement by picking another location or by dragging them to the location you want.
Change the scale of the vertical (value) axis in a chart
Click the drop down box under Labels and choose a label position. To change the point where you want the horizontal (category) axis to cross the vertical (value) axis, under Floor crosses at, click Axis value, and then type the number you want in the text box.
Change axis labels in a chart in Office - Microsoft Support
Change axis labels in a chart in Office. Applies To. In charts, axis labels are shown below the horizontal (also known as category) axis, next to the vertical (also known as value) axis, and, in a 3-D chart, next to the depth axis. The chart uses text from your source data for axis labels.
Use charts and graphs in your presentation - Microsoft Support
Use the Chart Elements button to show, hide, or format things like axis titles or data labels. Or use the Chart Styles button to quickly change the color or style of the chart. Tip: The Chart Filters button is a more advanced option that shows or hides data in your chart. When you’ve finished, close the worksheet.
Change the display of chart axes - Microsoft Support
Change the alignment and orientation of labels. You can change the alignment of axis labels on both horizontal (category) and vertical (value) axes. When you have multiple-level category labels in your chart, you can change the alignment of all levels of labels.