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.

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

On 2ÔÂ8ÈÕ, ÏÂÎç4ʱ49·Ö, Andy Pope wrote:
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

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 - Excelhttp://www.andypope.info

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

yours.fujing1003

<blush thanks! </blush

fujing1003 wrote:
On 2ÔÂ8ÈÕ, ÏÂÎç4ʱ49·Ö, Andy Pope wrote:

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

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 - Excelhttp://www.andypope.info


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

yours.fujing1003


--

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

@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

That's correct.

By the way the tutorial is Tushar Mehta's.

Cheers
Andy

fujing1003 wrote:
@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, Microsoft MVP - Excel
http://www.andypope.info