AJP Excel Information AJP Excel Information

Delete a single entry from the legend



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

Created August 2004
Last updated 5th August 2014 

Return to main page Chart Section VBA section Fun and games section Forum files Tips section Links section Book section Site information Site Search RSS feed Top of page

Microsoft® and Microsoft® Excel are registered trademarks of the Microsoft Corporation.
andypope.info is not associated with Microsoft. Copyright ©2007-2016 Andy Pope