Could you remove the data table from the chart, and make your own table in
the cells near the chart? Compared with the relative inflexibility of a
chart's data table, a worksheet table lets you put any data into it, format
it however you want, etc.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Rose" wrote in message
...
Is there any way to choose only part of my data to appear in a data table?
I
have a line and bar chart on two axis and would like the bar data in a
data
table and the line data with data labels.