Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dr. Mark F.
 
Posts: n/a
Default How do I display a data table in an Excel 2002 chart?

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   Report Post  
John Mansfield
 
Posts: n/a
Default

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   Report Post  
Dr. Mark F.
 
Posts: n/a
Default

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   Report Post  
Tushar Mehta
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
multiple or changing colours in a data table on an excel chart fo. Kerri Buxton Charts and Charting in Excel 2 December 23rd 04 08:39 PM
How many data points can you have in an Excel for a Scatter Chart. gregran Charts and Charting in Excel 3 December 10th 04 08:31 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 04:56 AM
Excel 97 chart opened in Excel 2003 - Source Data problem DHunt Charts and Charting in Excel 0 December 6th 04 09:05 PM
Extending a Chart Data Series from an Array - Can it be done? Jon Peltier Charts and Charting in Excel 4 November 30th 04 04:30 AM


All times are GMT +1. The time now is 01:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"