How do I offset TWO columns behind another TWO columns?

M

Moxy1980

I have created a bar chart with 4 colums of information. I would lik
two of the columns to be behind the other two colums. Can anyone hel
me with how to do this.

I have tried creating the chart then offsetting but obviously all th
coumns offset behind each other.

Thanks in anticipation
 
A

Andy Pope

Hi,

Set the two columns you want in front to be on the secondary y axis.

Cheers
Andy
 

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

One extra x axis item that wont go away - can anyone help? 3
OFFSET for multiple columns & combobox format 2
How do I assign a bar to the right axis? 9
How do I move a chart using a macro? 1
Overlapping Bars Chart & Two Y Axes: how? 1
Two columns per location 1
Two Data Sets: Stacked Column Chart 1
Resizing columns [same data source] 2

Top