Excel's data tables are really not very flexible. I never use them. If I
need a table to accompany a chart, I create it in the cells below or next to
the chart. I can decide what data to show, how to format it, etc.

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


"BNT1 via OfficeKB.com" <u19326@uwe wrote in message
news:85a75e8c171b6@uwe...
Thanks Jon

I understand your first point, however, would this not keep the chart
spread
out, owing to the other columns hiden?

Would you be able elaborate further on your secound solution, as this
looks
more inviting ! or perhaps a web site for guidence

regards

Jon Peltier wrote:
You could format the unwanted series so as to hide them in the chart (no
border, no fill).

Or you could use the worksheet space around the chart, which has much more
flexible formatting and data capabilities than a chart's data table.

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

hi

[quoted text clipped - 12 lines]

Brian

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200806/1