How to only show a legend when there are data points

05-02-2005, 10:42 AM

manse

Registered User

Join Date: 02 May 2005

Posts: 5

manse is an unknown quantity at this point

How to only show a legend when there are data points

Hi,

I have a line chart using 6 data series but I usually only have data points for 2 or 3 series and I want to only show a legend for the series for which there are data points.

Is there a way to set the chart to do this automatically?

Thanks in advance for any advice.

Bookmarks

New topics in Excel Charting

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Trackbacks are Off Pingbacks are Off Refbacks are Off

Forum Jump

All times are GMT -4. The time now is 10:22 PM.