Hi,

No. Formatting, including hiding, of chart data table elements is very
restricted.

This may help
http://tushar-mehta.com/excel/newsgr...able/index.htm

Cheers
Andy

fujing1003 wrote:
Some times we need to show source data with chart. we could turn it
true by use specific name in axis(xlcategory) or by using source data
's linking picture . Both of these could help us to show specific
series.
and as all of us know that, the chart's datatable will show all of the
series' value.
I want to know whether we can hide any dummy series in chart's data
table directly.

Thanks for your answer in advance.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info