Column Chart with 2 axes

G

Greenfield

I have a column chart with 2 bars in each catagory (total 12 bars, 6
categories). I want to put each data series on a separate axis. When I
choose the second data series, than format data series, than axis and click
on second axis, the chart goes from a column chart to a stack bar chart.
Does anyone know how to keep the chart as a two column chart on separate axes?
 
S

ShaneDevenshire

Hi Greenfield,

If I catch your gist, you want the columns side by side even thought they
are on different axis? I invented a method to do this 15 years ago, which is
still used today - you need to create dummy columns.

Data1 Dummy1 Dummy2 Data2
3 3 3 6
2 1
4 3
1 5
8 2
4 8

Plot the data as a regular column chart. Then double click any series and
on the Options tab set the Gap Width to 0. Remove the values in columns 2
and 3 they were just there for looks. In the legend select the legend
enteries for each dummy series and press Delete.

I hope this is what you want although you may be interested in a
stacked-cluster chart.

Cheers,
Shane Devenshire
 
G

Greenfield

Thank you. Your tip is exactly what I needed.

ShaneDevenshire said:
Hi Greenfield,

If I catch your gist, you want the columns side by side even thought they
are on different axis? I invented a method to do this 15 years ago, which is
still used today - you need to create dummy columns.

Data1 Dummy1 Dummy2 Data2
3 3 3 6
2 1
4 3
1 5
8 2
4 8

Plot the data as a regular column chart. Then double click any series and
on the Options tab set the Gap Width to 0. Remove the values in columns 2
and 3 they were just there for looks. In the legend select the legend
enteries for each dummy series and press Delete.

I hope this is what you want although you may be interested in a
stacked-cluster chart.

Cheers,
Shane Devenshire
 
S

ShaneDevenshire

Hi Bernard,

How was your trip home? By the way does Jon's website credit me? I
published this in the early 90's in a number of computer magazines.
 
J

Jon Peltier

Shane -

I developed the same technique independently, without ever seeing your prior
references. If any of them are linkable, I'll be glad to include a link in
the tutorial.

- Jon
 
S

ShaneDevenshire

Hi Jon,

Sorry we missed you at the Summit!

Listed below in reverse chronological order. I don't know if there are any
links to these:

1. Excel Expert Solutions, Que, 1996, Designing a Dual-Axis Column Chart,
pgs. 718-721.
2. Macworld February 1995, Quick Tips, Impossible column Chart
3. PC Magazine January 1995, page 272, Spreadsheets: Excel Charts with two
Y-Axes.
4. Bank of America - PC Computing tips for the Mac, November 1986, page 4.
 
J

Jon Peltier

Shane -

You definitely have the "prior art" covered. Thanks for the links.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
774-275-0064
208-485-0691 fax
(e-mail address removed)
http://PeltierTech.com/
_______
 

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

Top