| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Bar chart with Y Axes Categories | Charts and Charting in Excel | |||
| Chart Categories | Excel Discussion (Misc queries) | |||
| Column Chart - X axis too thin because of MANY categories. | Charts and Charting in Excel | |||
| 3D chart categories | Charts and Charting in Excel | |||
| Need for categories to be displayed in chart | Charts and Charting in Excel | |||
Linear Mode
