| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Aling multiple sets of data by header column | Excel Discussion (Misc queries) | |||
| how do I import variable data into a word document | Excel Discussion (Misc queries) | |||
| Charting Data over 256 Columns | Charts and Charting in Excel | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| Charting Data Series vs. Data Points? | Charts and Charting in Excel | |||
Linear Mode
