How do I offset TWO columns behind another TWO columns?

Moxy1980 · #1 10-25-2005, 09:42 AM

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!

#2 10-25-2005, 01:05 PM

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

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

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)