Hi All,

I suspect i'm asking to much of the pivot table charting abilities in Excel
but here goes.

I have created a pivot table from which there is data i want to chart and
data i'd like to display just in a tabular format. I found out about the Data
table functionality which is something i believe i can make use of to get
this tabular out put in the chart area.

The problem is that i only want to display one column from the pivottable as
a chart series, the other 2 (its always a 3 column layout) i want to siplay
in the data table. Is there any way in Excel 2007 that i can do this. It
seems to tie the data source to the whole pivot table which doesn't make it
easy to alter.

My two thoughts on this we
a) is there some way i could flatten the pivot table and then remove the
series from the chart and entries from the data table.
b) Is it possible through the Excel object model that i could delete entries
from the chart and data table .

All help is greatfully recieved on this matter.

Regards,

G