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


--
Hayley44
------------------------------------------------------------------------
Hayley44's Profile: http://www.excelforum.com/member.php...o&userid=23803
View this thread: http://www.excelforum.com/showthread...hreadid=374561

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