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

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?

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

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

Legends vs Plotting wrote:
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?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info