Column - Column 2 Axis (no-overlap)

Hayley44 · #1 05-27-2005, 12:06 PM

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

#2 05-27-2005, 02:05 PM

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
>
>

#3 05-27-2005, 03:05 PM

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
>
>

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)