Show data table

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

- 27 Aug 2004 21:38 GMT

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.

Reply to this Message

Tushar Mehta - 27 Aug 2004 22:31 GMT

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

Signature

Regards,

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

> 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.

Reply to this Message

Jon Peltier - 27 Aug 2004 22:58 GMT

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

> 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.

Reply to this Message