Secondary Axis Chart in XP

Leonie · May 2nd, 2002, 07:56 AM

If I create a chart in Excel XP with a secondary axis, the bars are overlapping - is there a way of changing the graph so that the bars are displayed next to each other? It must be a column chart - no combination.
Please help!

Anne Troy · May 2nd, 2002, 08:02 AM

You may just need to make your chart wider. Otherwise, double-click one of the columns in the chart and see the gap width setting.

Leonie · May 3rd, 2002, 04:39 AM

Tried but cannot get it to work - changed gap width setting and changed overlapping
Thanks anyway

Quote:

On 2002-05-02 07:02, Dreamboat wrote:
You may just need to make your chart wider. Otherwise, double-click one of the columns in the chart and see the gap width setting.

May 2nd, 2002, 08:02 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	You may just need to make your chart wider. Otherwise, double-click one of the columns in the chart and see the gap width setting. __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 2nd, 2002, 07:56 AM	#1
Leonie New Member Join Date: May 2002 Posts: 2	If I create a chart in Excel XP with a secondary axis, the bars are overlapping - is there a way of changing the graph so that the bars are displayed next to each other? It must be a column chart - no combination. Please help!