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

  • Thread starter Legends vs Plotting
  • Start date
L

Legends vs Plotting

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
Filtered view of Visio Chart 0
Legend Overlaps Chart in Excel 2007 4
changing the name in the legend 2
How to change series plotting order without changing legend order? 6
chart legend changing when I use Select data 1
Hide line and legend when data not present 0
Data Table at Base of Chart 4

Top