2 questions

[Sally Sibthorpe]

I have two Excel charting questions:
1. Can you make the x axis display on the right side of the chart instead of
the left? (and no, the "...crosses at maximum value" checkbox does not make
it do this)

2. Can you create an overlay chart with an additional axis with both data
series being instacked bar format? I can create on with stacked bar and
line, but not two stacked bar ones...they just stack on top instead of being
two seperate ones.

 

[Jon Peltier]

1. Can you make the x axis display on the right side of the chart instead
of
the left? (and no, the "...crosses at maximum value" checkbox does not
make
it do this)

What does "crosses at maximum" do? To move a vertical axis from one side to
the other, you must double click the horizontal axis and choose a value for
the vertical axis to cross at.

2. Can you create an overlay chart with an additional axis with both data
series being instacked bar format? I can create on with stacked bar and
line, but not two stacked bar ones...they just stack on top instead of
being
two seperate ones.

You might be asking about this:

http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html

- Jon

 

[Sally Sibthorpe]

I don't understand what you mean by choosing a value for the axis. All I
want is to display it on the other side, and not change anything else. In
much older versions of Excel, you used to be able to just drag the info from
the left axis to the right, but that doesn't work anymore.

And no, your link did not show what I am trying to do. I want stacked
column chart desplayed on two axis...you know...the columns are striped
horizontally with the different data. The examples in your link were either
bar or column charts, but they weren't stacked.

 

[Jon Peltier]

I don't understand what you mean by choosing a value for the axis. All I
want is to display it on the other side, and not change anything else. In
much older versions of Excel, you used to be able to just drag the info
from
the left axis to the right, but that doesn't work anymore.

Dragging an axis from side to side of a chart was never possible in any
version of Excel I've ever used (starting in about Excel 2).

If you want the Y axis on the opposite side of the chart, double click the X
axis, and on the Scale tab, check the Value Axis Crosses at Maximum box. I
don't know why this didn't work for you.

And no, your link did not show what I am trying to do. I want stacked
column chart desplayed on two axis...you know...the columns are striped
horizontally with the different data. The examples in your link were
either
bar or column charts, but they weren't stacked.

How does a stacked chart refer to different axes? Each item in the stack has
to be plotted against the same scale.

- Jon

 

[Sally Sibthorpe]

When I checked that box, nothing moved. I was trying to get the scale to
move to the left, so I could lay one chart on top of another and be able to
see both scales. This was an alternative to the stacked chart on two axis
that I was working with below.

Regarding the stacked charts, I am plotting two different kinds of data.
One is dollars, and the other is numbers of people, and both are over 5 years
time. The need to have seperate scales because you can't compare money with
people and have it make any sense.

Please note...this idiotic chart is my boss' idea, not mine.

 

[klass]

He's given you the right instructions.

are you sure that you're using the right axis?

 

[Sally Sibthorpe]

I want to move the one that is on the left to the right side of the chart.
The bottom one I want to stay put where it is.

 

[Jon Peltier]

So double click the bottom axis and check the Crosses at Maximum box on the
Scale tab.

- Jon

 

[Jon Peltier]

Hi Sally -

Don't worry, I've had bosses like that. In fact, the last boss I had was
such a nightmare, he was pathologically stupid. He then got a job with one
of our suppliers, a hopeless crew, and the word was that when he left, the
average IQ at both companies went up. Anyway, now I'm the boss, so there are
no stupid decisions around here, at least none I can't fix.

I don't understand how you're stacking two different data types together. If
the data are not compatible, you will never get them to stack. The only
thing I can think of is that you have dollars stacked on dollars, and next
to it people stacked on people. You might want to combine these approaches:

http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html
http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html

- Jon

 

[HEK]

Hi Sally:
Frankly this thread confuses me a lot. Could it be that yr boss said
something like "make a chart with a right axis?". Maybe he meant to ADD a
right axis. This wld make sense to me, the left axis for the dollars, the
right one for the people. You can have yr two columns or lines w/ a common
x-axis, using different colours, etc. Whatever, such chart wld bring across
the message I think.
Could this change of tack help you out of the woods?
HTH,
Henk