Excel Charts : Delete a Single Entry From Excel Chart Legend

< Back to Search results

 Category: [Excel]  Demo Available 

Excel Charts : Delete a Single Entry From Excel Chart Legend


Got a Excel Chart question? Use our FREE Excel Help!

With Excel charting it is sometimes necessary to use additional data series in order to achieve the effect in a chart you want. Unfortunately these extra data series can create unwanted legend entries.

This simple chart contains a series, called Dummy, that we require in the chart but not in the legend.

The first step to removing the Dummy legend entry is to select the legend with a single mouse click. Then with another single click you can select the legend entry. You can now use the delete key to remove the entry.

Warning: Make sure you DO NOT select the legend marker as deleting this will remove the data from the chart as well.

We should now have a chart with the legend only containing the information we want.


See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets


See also:

Excel Charts : Automatically Updating Custom Leader Lines


Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.


Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.


stars (0 Reviews)