You may want to adapt the ideas at
Custom Chart Table
http://www.tushar-mehta.com/excel/ne...able/index.htm

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Hello,

Is it possible to not show a series in the Data Table but have the
line or value shown in the chart? I have one or two series that I
don't want to see in the Data Table, but the rest of the series I want
to see.

Thanks!