 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / September 2006How 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? 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 > 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?  SignatureAndy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.