Column - Column 2 Axis (no-overlap)

Hi,
I have spent hours trying to work out how I can create a chart with 2x Y axes that are column - column - that don't overlap but are represented by to bars next to each other - NOT OVERLAPPING. I feel that I have tried everything - I have tried fiddling with the overlap ect... but I can't seem to get two seperate bars.

I would love any hints and even to know if is possible or not.

I thankyou in advance for you response.
Hayley

Hayley -

Try this:

http://peltiertech.com/Excel/Charts/...OnTwoAxes.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Hayley44 wrote:

> Hi,
> I have spent hours trying to work out how I can create a chart with 2x
> Y axes that are column - column - that don't overlap but are
> represented by to bars next to each other - NOT OVERLAPPING. I feel
> that I have tried everything - I have tried fiddling with the overlap
> ect... but I can't seem to get two seperate bars.
>
> I would love any hints and even to know if is possible or not.
>
> I thankyou in advance for you response.
> Hayley
>
>

Hayley,

I'm not sure what you are asking with regard to axes. Do you want:

1) Series 1: X series - Y series
Series 2: 2nd X series - 2nd Y series
2) Series 1: X series - Y series
Series 2: Same X series - 2nd Y series.

Do you want to have a secondary Y axis or have the Y axis labels for each Y
series to be the same?

An example of your data might help me.

"Hayley44" wrote:

>
> Hi,
> I have spent hours trying to work out how I can create a chart with 2x
> Y axes that are column - column - that don't overlap but are
> represented by to bars next to each other - NOT OVERLAPPING. I feel
> that I have tried everything - I have tried fiddling with the overlap
> ect... but I can't seem to get two seperate bars.
>
> I would love any hints and even to know if is possible or not.
>
> I thankyou in advance for you response.
> Hayley
>
>
> --
> Hayley44
> ------------------------------------------------------------------------
> Hayley44's Profile: http://www.excelforum.com/member.php...o&userid=23803
> View this thread: http://www.excelforum.com/showthread...hreadid=374561
>
>