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?
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.