If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|