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
|
|||
|
|||
Show data table
I am using Excel in Office 2003. Under chart opition I
swelect 'show data table' Can I edit that table? In the data table that appears I want to add letters after the numbers. |
#2
|
|||
|
|||
No, the data table cannot be edited. In fact, XL has rather limited
support for it. Instead, you may want to simulate the effect of a data table. See 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 , says... I am using Excel in Office 2003. Under chart opition I swelect 'show data table' Can I edit that table? In the data table that appears I want to add letters after the numbers. |
#3
|
|||
|
|||
Excel's chart data tables are not very flexible. The data in them must
somehow appear in the chart (although you can hide a chart series by choosing None for line, marker, border, fill, or whatever), and any series in the chart must appear in the table. The formatting is also not too flexible. I always suggest to people that they make a table in the cells near a chart, so they can format it how they like, and include whatever data they want. Tushar Mehta has a few suggestions about data tables on his web site: http://tushar-mehta.com - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ wrote: I am using Excel in Office 2003. Under chart opition I swelect 'show data table' Can I edit that table? In the data table that appears I want to add letters after the numbers. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Starting over with appending data from one flat table to multiple relational tables. | Stranger | Running & Setting Up Queries | 1 | August 5th, 2004 04:32 AM |
Moving data from popup to subform | John Nurick | Database Design | 0 | May 6th, 2004 06:19 AM |
Data Table | Max | Worksheet Functions | 1 | April 12th, 2004 04:12 AM |