How to edit A Chart In Excel 2016
How to Change Elements of a Chart like Title, Axis Titles, Legend etc in Excel 2016
0:00 / 0:00
Quality:
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
axis
the data labels display the values as
you can see if you select it the data
table if you want to display the values
as a table below the chart error bars
are used if the values represented are
not accurate and can have margin of
error the gridlines if you want to
display the gridlines or not legend
gives the series like this sales chart
is for year 2016 to change the legend
click on the legend under chart tools
click on design tab click on select data
select the legend entry and click on
edit and change the series name as you
wanted like year 2016 click OK click OK
you can see the legend is changed to
year 2016 the trend line shows the sales
trend it is more reliable when the R
square value is near 1 this is how you
can change the elements of a chart if
you liked this video please subscribe to
our Channel
![Microsoft Excel 2016 - Create and Manage your Charts and Graphs [COMPLETE]](https://i.ytimg.com/vi/KOOGje8W3P0/mqdefault.jpg)
