Make the chart in normal way
On the chart, right click a column of the 'unwanted' data series, use Format
Data Series
Format to No Line & No Fill
Appearance is OK if the unwanted is not in the centre.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"martymi" wrote in message
...
I want to show 3 categories in a data table at the bottom of a column chart
but only chart 2 of the categories in the diagram itself. can i do this?
how?
--
martymi