Remove Row (Data Legend) in Data Table

[aimee415]

Hello,

I'm using Excel 2007 and created a 2D stacked chart which shows a Data Table with the Data Legend underneath the chart.

There is ONE row/series (Grand Total) that I want hidden from this Data Table. I only added it to show the grand total on top of the stacked chart (line bar, invisible fill/line, data label centered above).

Is there a way I can remove this one grand total series from the Data Table?

Thanks,
Aimee

 

[VoG]

Sorry but I don't think that you can. Data tables are very limited.