Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - Are Users Experiencing Problems with Charts? | Charts and Charting in Excel | |||
Getting rid of unusable charts? | Excel Discussion (Misc queries) | |||
Pasting worksheet with embedded charts | Charts and Charting in Excel | |||
How To Change Fonts In Multiple Charts in a Workbook? | Charts and Charting in Excel | |||
Excel Charts Linked to Spreadsheets | Charts and Charting in Excel |