How to Add and Remove Chart Elements in Excel Office 365?
Tags: addandremovechartele
Published: 2021-08-19 04:51:45

---
title: How to Add and Remove Chart Elements in Excel Office 365?
published: true
date: 2021-08-11 16:54:19 UTC
tags: AddAndRemoveChartEle
canonical_url: https://geekexcel.com/how-to-add-and-remove-chart-elements-in-excel-office-365/
---

In this tutorial, we will guide you to know the step-by-step instructions to **Add And Remove Chart Elements In Excel Office 365.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

## Insert Line chart

- You need to **enter the data** in the Excel worksheet.
- For instance, we have shown the **list of items** purchased in the shop.

![](https://geekexcel.com/wp-content/uploads/2021/08/ex-list-of-items.png)<figcaption>List of items</figcaption>

- You have to **select the table** and click on the **Insert tab**.
- Then, you need to **select the Line Chart** under the **[Chart](https://geekexcel.com/create-bar-charts-in-excel-office-365-simple-easy-steps/)**section.

![](https://geekexcel.com/wp-content/uploads/2021/08/click-line-chart.png)<figcaption>Select Line Chart</figcaption>

- After selecting the **chart type** , you will see the list of items in the **chart format**.

![](https://geekexcel.com/wp-content/uploads/2021/08/ex-line-chart.png)<figcaption>Line Chart</figcaption>

## Add Data Label Element to The Chart

- You need to click on the **plus sign** to add the data labels to the chart.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-on-the-plus-sign.png)<figcaption>Click on the plus sign</figcaption>

- Then, you have to click on the **data labels** option.

![](https://geekexcel.com/wp-content/uploads/2021/08/click-on-data-label.png)<figcaption>Click on Data labels</figcaption>

- Now, if you want to show **data labels on the left, right, center, below** , etc. then you have to click on the **Data Labels** again.
- After that, you need to expand the data label category, and it will **open the options** available for adding the alignments.

![](https://geekexcel.com/wp-content/uploads/2021/08/click-on-left-option.png)<figcaption>Click on the left option</figcaption>

## Add Vertical Grid lines to the Chart

- If we want to **add the primary major vertical grid line** element to the chart, you have to click on the **plus sign (+)**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-on-the-plus-sign-1.png)<figcaption>Click on the plus sign</figcaption>

- Then, you need to move the cursor on the **Grid line option** and click on the **arrowhead sign**.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-on-grid-line.png)<figcaption>Click on the gridline option</figcaption>

- Now, you have to check the **primary major vertical grid lines** option.

![](https://geekexcel.com/wp-content/uploads/2021/08/click-on-primary-vertical-option.png)<figcaption>Click on primary major vertical grid lines</figcaption>

## Remove Chart Title Element From the Chart

- You need to **select the chart elements** and press the **delete** button to simply **remove** them from the chart.
- Now, the **fly-out menu** gives all the **options** it is in one place, and you don’t need to **select each element** one by one.

## Wind-Up:

In this tutorial, we guided you to learn the steps to **Add And Remove Chart Elements In Excel Office 365.** I hope it was explanatory and useful. If you have any doubts regarding Excel Formula, Functions, Charts, or VBA, then leave your **feedback** in the comment section below. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

Read Next:

- **[Simple Shortcuts for Grid Options in Microsoft Excel 365!!](https://geekexcel.com/simple-shortcuts-for-grid-options-in-microsoft-excel-365/)**
- **[How to Select Chart Elements in Excel Office 365 ~ A Complete Guide!!](https://geekexcel.com/how-to-select-chart-elements-in-excel/)**
- **[How to Add Horizontal or Vertical Average Line to a Chart in Excel?](https://geekexcel.com/how-to-add-horizontal-or-vertical-average-line-to-a-chart-in-excel/)**
- **[Insert Sheet in Microsoft Excel 2007?](https://geekexcel.com/insert-sheet-in-microsoft-excel-2007/)**
- **[Excel Formulas to Extract Multiple Lines From a Cell ~ Easy Tricks!!](https://geekexcel.com/excel-formulas-to-extract-multiple-lines-from-a-cell-easy-tricks/)**