I don't know what you can do in a chart's data table. I generally make a
table in a range on the worksheet. In the worksheet you can pretty much
format everything however you like, and include or exclude data regardless
of whether it's even in the chart. If the chart is embedded in the
worksheet, use a range beside or below the chart for your table. If the
chart is on its own chart sheet, make your table in any worksheet, then use
the camera tool to place a dynamic picture of the table in the chart sheet.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______
