How to Change Elements of a Chart like Title, Axis Titles, Legend etc in Excel 2016

Toggle fullscreen Fullscreen button

Sharing buttons:

you can change the chart elements like

title access titles legend etcetera so

that the chart conveys more information

to the users the example worksheet has a

chart for sales data of a company for a

year to change the chart elements click

on the chart and click on plus sign to

the right of the chart Excel displays

the different chart elements you can see

some of them are by default activated to

change the title click on title type

whatever title you want

if you want to have titles to the axis

select the axis titles type the axis

title you want for vertical and

horizontal axis

like sales in dollars for the vertical


the data labels display the values as

you can see if you select it the data

table if you want to display the values