Ozgrid, Experts in Microsoft Excel Spreadsheets

Excel Charts : Delete a Single Entry From Excel Chart Legend

| | Information Helpful? Why Not Donate.


Also see our huge range of Charting Software . 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.

Back to Excel Charts Index

Also see our huge range of Charting Software

Excel Dashboard Reports & Excel Dashboard Charts 50% Off Become an ExcelUser Affiliate & Earn Money

Special! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $64.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to special@ozgrid.com 31 days after purchase date.

Instant Download and Money Back Guarantee on Most Software


Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

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

Some of our more popular products are below...
Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To...... | Analyzer Excel | Downloader Excel | MSSQL Migration Toolkit | Monte Carlo Add-in | Excel Costing Templates