Posted to microsoft.public.excel.charting

external usenet poster

Posts: 204

Hide zero entries from legend

I have a pie-chart which refers to 50 rows of data. There are never any more
than 5 or 6 with any values, and the pie chart looks fine... EXCEPT... the
legend shows all 50 entries. Is there a way to tell it to ignore (or not
display) any entries that have a zero value (and therefore do not show in
the pie)?

Thanks

M

Reply With Quote

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

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can I ungroup legend entries?	Orhan	Charts and Charting in Excel	1	January 2nd 06 01:10 PM
Sort Legend Entries	Coolboy55	Charts and Charting in Excel	1	August 28th 05 01:27 AM
Chart Legend Entries	BillCPA	Excel Discussion (Misc queries)	1	July 27th 05 11:32 PM
Legend Entries	nelly	Charts and Charting in Excel	2	June 30th 05 01:22 PM
Specifying Legend Entries	Joey Chart User	Charts and Charting in Excel	1	June 23rd 05 12:34 AM

All times are GMT +1. The time now is 05:35 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us