Add Chart Element

Many people does not know how to restore chart axis after accidentally delete it. In this article, I will show you how you can add chart element.

Here is a basic chart inserted from the data next to it.

Excel puts pretty much everything you need on a default chart. You can add or remove any chart element as you like.

Easiest way to add chart element is, for data labels. If you right-click on a data series and select “Add Data Labels” option, data labels will appear at the end of each data series.

Excluding data labels, you need to click on the chart and navigate to “Add Chart Element” menu from chart tools to add chart element.

When you click on this button, a dropdown menu will appear with every chart element that you can add to your chart. All you need to do is to select one.

You can preview a chart element on your chart by hovering over it on the menu.

If you are not too familiar with details of charts, you can find out chart elements that you might not know about by playing with these options.

You might also noticed a button next to “Add Chart Element”, which reads “Quick Layout”. This button gives you a selection of preset chart layouts with different chart elements already arranged.

Just like the previous menu, you can preview different layouts on your chart by hovering over layout options. If you like any of them, you can apply that layout by selecting that layout. You might find it useful to apply a preset layout first than fine tune your chart with add chart element options.

Remaining buttons to the left are for chart color themes and preset chart styles. They don’t add or remove chart elements, they only change colors and style of chart elements. You can check them to see what kind of options are available.

Leave a Reply

Your email address will not be published. Required fields are marked *