View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Showing data table on a chart - How do I edit the info?

I think all you can do, since you can't edit the contents of a data table,
is to change the name of each series to " ". It might be easier to construct
a custom data table in the worksheet (not in the chart) with links to the
data, so you can lay out, format, and edit the table however you like.

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


"Tony Law" wrote in message
...
I have a line chart and I set it to show the data table under chart
options.
In the left most column, it says "Series 1", "Series 2", and "Series 3"
from
top to bottom. How do I get rid of that?