Chart's DataTable

F

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.
 
F

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
Click to expand...

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

yours.fujing1003
 
F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Including Totals in Chart's data table 1
Named data series won't dispay in Excel 2007 4
Charting only Used Range with Named Ranges 3
Line chart, multiple series, data is inter-mixed 2
Stretch data series in chart 1
Line chart - time series - category axis date format (2007 VBA) 1
How can I add values from several worksheets in a line chart seri. 1
Chart - Secondary Y-axis with different values/scale 2

Top