Can i hide specific data series in an excel chart yet show the values in the legend???

tony__77

Guest

Posts: n/a

27th Sep 2007

Hi,

Hoping somebody can help me, i have created a chart in excel and have
4 values followed by a sub total then remaining amount and finally
total amount. I need them displayed in the legend as they are with all
the single values then the 3 top level amounts but only want the three
final amounts (sub total, remaining and total) in the graph to show.

If anybody can help i would really appreciate it.

Thank you

Tony

« Extract Data | copy unique values to validation list »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

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 On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Hide Legend With No Data in Series	GENESIS	Microsoft Excel Misc	2	26th Mar 2011 07:29 PM
Zero values not legend, Value grater then zero show data and legend	Pamela	Microsoft Excel Misc	0	27th Jan 2009 10:29 PM
Hide series names for unused data from chart legend	=?Utf-8?B?TmVpbCBHb2xkd2Fzc2Vy?=	Microsoft Excel Charting	4	10th Feb 2006 07:13 PM
Chart Legend Items: hide/show	Richard Ahlvin	Microsoft Excel Charting	3	29th Aug 2005 03:33 PM
How to hide a dummy series in a chart legend?	holg3r	Microsoft Excel New Users	2	14th Jul 2005 09:04 AM