|
column chart with 3 categories
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 |
column chart with 3 categories
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 |
column chart with 3 categories
That worked -- thank you. Now I've lost my secondary category in the plot
area. any ideas how to get it back? -- martymi "Bernard Liengme" wrote: 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 |
| All times are GMT +1. The time now is 07:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com