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