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.
|Excel Charts : Automatically Updating Custom Leader Lines|
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.