How do I offset TWO columns behind another TWO columns?

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

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

Thanks in anticipation!

Hi,

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

Cheers
Andy

Moxy1980 wrote:
> I have created a bar chart with 4 colums of information. I would like
> two of the columns to be behind the other two colums. Can anyone help
> me with how to do this.
>
> I have tried creating the chart then offsetting but obviously all the
> coumns offset behind each other.
>
> Thanks in anticipation!
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info