Column Column 2 axes

[Dave]

Hi, How do I make a column-column graph but use 2
different y-axes? Thanks

 

[Debra Dalgleish]

Jon Peltier has instructions for this on his web site:

http://www.geocities.com/jonpeltier/Excel/Charts/format.html#Col2Axes

 

[Jon Peltier]

Dave -

Check out this page:

http://www.geocities.com/jonpeltier/Excel/Charts/ColumnsOnTwoAxes.html

- Jon

 

[Father Guido]

Dave -

Check out this page:

http://www.geocities.com/jonpeltier/Excel/Charts/ColumnsOnTwoAxes.html

- Jon

Hi,

I went there Jon, it looks really nice for a 2 column chart. How would
it be set up for 4 columns on the primary and only 1 column on the
secondary.

Father Guido
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
I plan on living forever... so far, so good

 

[Debra Dalgleish]

Follow Jon's instructions, and use four dummy series for the Primary
axis, instead of one.

Ser1 P0 P1 P2 P3 S0 Ser2 Ser3 Ser4 Ser5
Alpha 3 10 72 95 36 52
Beta 5 66 77 88 59
Gamma 4 84 47 68 62

 

[Father Guido]

Thanks Debra, but that didn't work for me. I actaully have 4
small data series, and one large series. I reversed the data
in the example you gave me, and it worked perfectly. 8^)

Ser1 P0 P1 P2 P3 S0 Ser2 Ser3 Ser4 Ser5
Alpha 36 40 40 40 40 7 9 3 5
Beta 55 6 7 8 5
Gamma 49 8 4 6 6

Thanks very much for the idea!!!

Norm
___________________________________________________

Follow Jon's instructions, and use four dummy series for the Primary
axis, instead of one.

Ser1 P0 P1 P2 P3 S0 Ser2 Ser3 Ser4 Ser5
Alpha 3 10 72 95 36 52
Beta 5 66 77 88 59
Gamma 4 84 47 68 62

Father Guido
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
I plan on living forever... so far, so good