How do I Add a variable in the legend without charting the data?

G

Guest

I have three variables that need to appear in my legend but only two of them
should appear in the chart. How do I show the third variable in the legend
without it being plotted in the chart?
 
A

Andy Pope

Hi,

You can add a third series to the chart so that the legend item appears
but set the data to be plotted to be zero or #N/A such that the column
or line is not displayed.

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a bubble chart with more than 2 variables 0
changing the name in the legend 2
Change order of items in a legend 1
chart legend changing when I use Select data 1
Legend and text entry 1
How do I find the series associated with a given legend entry. 4
Legend on Chart 7
Legend Overlaps Chart in Excel 2007 4

Top