Show data table

[Guest]

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.

 

[Tushar Mehta]

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/newsgroups/data_table/index.htm

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jon Peltier]

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/
_______