column chart with 3 categories

M

martymi

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?
 
B

Bernard Liengme

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
 
M

martymi

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.

Ask a Question

Similar Threads

Filtered view of Visio Chart 0
Excel - Wich Function should I use? 1
Flatline on line chart 1
Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
Crating User Form to Add Names 1
Scatter chart with categories on x-Axis 2
Radar Chart questions 0
Move Chart with Text 0

Top