Select the data, go to insert menu -> Charts -> Line Chart. Here, I have data of sales done in different months in an Excel Spreadsheet. Example: Quickly Add or Remove Excel Chart Elements Let's see an example to understand how you can add or remove chart elements. You can choose from the listed settings or click on the more options to customize that chart element. If you click on it, it will show customized options for adding that chart element. When you hover over a chart element in the menu, you will see an arrowhead after that chart element. When you tick a checkbox Excel will add that chart element with default setting on the chart area. This menu is represented as a plus (+) sign.Īs soon as you click on this sign, all the chart elements will be shown with checkboxes before them. ![]() Since Excel 2013, Mircosoft provided a fly-out menu with Excel Charts that let's us add and remove chart elements quickly. How to add or remove the Excel chart elements from a chart?īefore Excel 2013, we used the design tab from the ribbon to add or remove chart elements. Basically everything except the series and chart area in a chart is a chart element. The axis, data labels, gridlines, chart titles, legends, error bars, etc.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |