Column Column 2 axes

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Hi, How do I make a column-column graph but use 2
different y-axes? Thanks
 
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
 
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
Click to expand...


Father Guido
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
I plan on living forever... so far, so good
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Column-Column on 2 axes 2
graph column line graph with two axes 1
2 y-axes PivotChart 1
Creating a clustered column chart 1
problem with scatter diagram excel 2007 2
X axis on 0 on Line-Column on 2 Axes 1
how can i get a "Column - Line on 2 axes" graph? 1
colum graph on 2 axes 2

Back
Top