Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am unable to display data tables in Excel 2002 charts, because the "Data
Table" tab does not appear under the "Chart Options" menu as in does in Office 97, and as the help file says that it should. Any suggestions? |
#2
![]() |
|||
|
|||
![]()
Dr. Mark,
Unfortunately data tables are not available for every chart that Excel offers. For example, data tables are not avaiable for XY, pie, doughnut, radar, bubble, and surface charts. Could it be that you're using one of these? ---- Regards, John Mansfield http://www.pdbook.com "Dr. Mark F." wrote: I am unable to display data tables in Excel 2002 charts, because the "Data Table" tab does not appear under the "Chart Options" menu as in does in Office 97, and as the help file says that it should. Any suggestions? |
#3
![]() |
|||
|
|||
![]()
Thank you kindly John. In fact, the problem did arise in conjunction with an
xy chart. After your post I changed it to a line chart and was able to add the data table. Unfortunately, the help file doesn't specify which chart types are and are not capable of generating data tables, and the logic isn't apparent to me. Thanks again for taking the time to respond Mark F. "John Mansfield" wrote: Dr. Mark, Unfortunately data tables are not available for every chart that Excel offers. For example, data tables are not avaiable for XY, pie, doughnut, radar, bubble, and surface charts. Could it be that you're using one of these? ---- Regards, John Mansfield http://www.pdbook.com "Dr. Mark F." wrote: I am unable to display data tables in Excel 2002 charts, because the "Data Table" tab does not appear under the "Chart Options" menu as in does in Office 97, and as the help file says that it should. Any suggestions? |
#4
![]() |
|||
|
|||
![]()
In addition to the comment you have already received, you might want to
check Custom Chart Table http://www.tushar-mehta.com/excel/ne...able/index.htm -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , "=? Utf-8?B?RHIuIE1hcmsgRi4=?=" <Dr. Mark says... I am unable to display data tables in Excel 2002 charts, because the "Data Table" tab does not appear under the "Chart Options" menu as in does in Office 97, and as the help file says that it should. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
multiple or changing colours in a data table on an excel chart fo. | Charts and Charting in Excel | |||
How many data points can you have in an Excel for a Scatter Chart. | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |