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.
Gallery
