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
_______


"BNT1 via OfficeKB.com" <u19326@uwe wrote in message
news:859cbac088aae@uwe...
hi

I am using a 100% stacked column graph to show the details of % late
against %
on-time delivered, for each week. To obtain these figures I had the,
total
delivered and late delivered volumes and did the necessary sums.
Q. how do I show the late and delivered volumes as well as the
precentages
in the Data Table below the chart, but only show the required 100% stack
chart for % late against % on-time
Help appricaiated

Regards

Brian

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