column chart with 3 categories

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
That worked -- thank you. Now I've lost my secondary category in the plot
area. any ideas how to get it back?
 
Back
Top