side by side column graphs
Hughie Broders
Using excel 2000 in Windows Me
I have 2 data series, each plotted with a different y-axis. I want to use
column graphs with each column within an x-category shown adjacent to one
another (ie side by side).
Currently they are shown as being 1 in front of the other so that there is
one series I cannot see. How can I have both series diplayed side by side
(within an x-category) as they would when there is only one y-axis.
Thanks in advance
Jon Peltier
What you can do is chart both series twice, once each on primary and on
secondary axes. For the primary axes, format series B so it has no border
and no fill; for the secondary axes, make series A similarly invisible. The
invisible series serve as placeholders.
I suppose the purist would use dummy series with zero values and no series
names as placeholders, but you don't need to be THAT anal about it.
- Jon
-------
Jon Peltier, Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______
In article <OosAfPF7BHA.396@tkmsftngp03>, Hughie Broders said...
Hughie Broders
I tried your method and I can;t seem to get it working--- when I plot more
than 2 series (copies or dummies) they still get placed "on top of" each
other... I still can't figure this out-----
Any other advice????
Thanks in advance
"Jon Peltier" <jonpe...@yahoo.com> wrote in message
news:eglvn7L7BHA.2360@tkmsftngp03...
Jon Peltier
(no border, no fill), and make the bottom B invisible.
If you still have a problem, send a sample file to my email address, and I'll
work it out for you.
- Jon
-------
Jon Peltier, Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______
In article <OLLbDTN7BHA.2232@tkmsftngp03>, Hughie Broders said...
Jon Peltier
If it helps, I answered a similar question in another group yesterday. Then
I realized I probably wasn't too clear in my response to your post. Here's
what I wrote to the other person, who was asking about clustered column
charts with primary and secondary axes:
_______
Yes you can get side by side clustered columns with primary and secondary
axes. But you need to use a trick to keep the bars from climbing all over
each other. Use some dummy series to provide placeholders to keep the
columns separate. If I have two series, A on the primary Y axis and B on the
secondary, I will include dummy series a and b like so:
[blank] A a b B
alpha 5 0 0 45
beta 6 0 0 50
gamma 7 0 0 55
delta 8 0 0 60
Keeping the blank cell in the top left helps Excel figure out how your data
is arranged.
Select the 5x5 range, including the blank cell. Run the chart wizard, and
create a column chart, plotted by columns. Select series D, press Ctrl-1
(numeral one) to open the format dialog, and on the Axis tab, choose
Secondary. Press the down arrow so dummy series b is selected, and press the
F4 key (to repeat the previous action). Now b and B are on the secondary
axis. Series A and dummy series b overlap, and next to them are series B and
dummy series a, which also overlap. But the zeros keep things cool.
Last step. Select the legend, then select the entry for series a (not the
filled square!). Press delete to remove the unneeded legend entry. Repeat
with the entry for series b.
_______
- Jon
-------
Jon Peltier, Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______
In article <OLLbDTN7BHA.2232@tkmsftngp03>, Hughie Broders said...
>