Chart's DataTable
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. |
Chart's DataTable
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 |
Chart's DataTable
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 |
Chart's DataTable
<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 |
Chart's DataTable
@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 |
Chart's DataTable
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 |
All times are GMT +1. The time now is 03:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com