Chart's DataTable

[fujing1003]

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]

Hi,

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

This may help
http://tushar-mehta.com/excel/newsgroups/data_table/index.htm

Cheers
Andy

 

[fujing1003]

Hi,

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

This may helphttp://tushar-mehta.com/excel/newsgroups/data_table/index.htm

Cheers
Andy

@Andy Pope
Thank you very much. I'm so lucky to meet you here.you are my idol!
Best wishes!

yours.fujing1003

 

[Andy Pope]

<blush> thanks! </blush>

@Andy Pope
Thank you very much. I'm so lucky to meet you here.you are my idol!
Best wishes!

yours.fujing1003

 

[fujing1003]

@Andy
Thank you very much!
After reading your tutorial,I got a understanding that there is
nothing we could do to change the series showing of MS chart's
datatable. and the only thing we could do is to use some tips such as
you mention in your article.
Thank you again for your help!
Best wishes!
Yours,fujing1003

 

[Andy Pope]

That's correct.

By the way the tutorial is Tushar Mehta's.

Cheers
Andy