View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tony__77 tony__77 is offline
external usenet poster
 
Posts: 2
Default Can i hide specific data series in an excel chart yet show the values in the legend???

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