2 questions

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.

> 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/...OnTwoAxes.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

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" wrote:

>
> > 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/...OnTwoAxes.html
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> http://PeltierTech.com
> _______
>
>
>

>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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

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.

"Jon Peltier" wrote:

>
> >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
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> http://PeltierTech.com
> _______
>
>
>
>

He's given you the right instructions.

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

Sally Sibthorpe wrote:
> 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.
>
> "Jon Peltier" wrote:
>
> >
> > >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
> > -------
> > Jon Peltier, Microsoft Excel MVP
> > Tutorials and Custom Solutions
> > http://PeltierTech.com
> > _______
> >
> >
> >
> >

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.

"klass" wrote:

> He's given you the right instructions.
>
> are you sure that you're using the right axis?
>
> Sally Sibthorpe wrote:
> > 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.
> >
> > "Jon Peltier" wrote:
> >
> > >
> > > >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
> > > -------
> > > Jon Peltier, Microsoft Excel MVP
> > > Tutorials and Custom Solutions
> > > http://PeltierTech.com
> > > _______
> > >
> > >
> > >
> > >
>
>

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Sally Sibthorpe" <[email protected]> wrote in
message news:[email protected]...
>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.
>
> "klass" wrote:
>
>> He's given you the right instructions.
>>
>> are you sure that you're using the right axis?
>>
>> Sally Sibthorpe wrote:
>> > 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.
>> >
>> > "Jon Peltier" wrote:
>> >
>> > >
>> > > >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
>> > > -------
>> > > Jon Peltier, Microsoft Excel MVP
>> > > Tutorials and Custom Solutions
>> > > http://PeltierTech.com
>> > > _______
>> > >
>> > >
>> > >
>> > >
>>
>>

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/ChartsH...sterStack.html
http://peltiertech.com/Excel/Charts/...OnTwoAxes.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Sally Sibthorpe" <[email protected]> wrote in
message news:[email protected]...
> 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.
>
> "Jon Peltier" wrote:
>
>>
>> >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
>> -------
>> Jon Peltier, Microsoft Excel MVP
>> Tutorials and Custom Solutions
>> http://PeltierTech.com
>> _______
>>
>>
>>
>>

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

"Jon Peltier" wrote:

> 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/ChartsH...sterStack.html
> http://peltiertech.com/Excel/Charts/...OnTwoAxes.html
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> http://PeltierTech.com
> _______
>
>
> "Sally Sibthorpe" <[email protected]> wrote in
> message news:[email protected]...
> > 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.
> >
> > "Jon Peltier" wrote:
> >
> >>
> >> >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
> >> -------
> >> Jon Peltier, Microsoft Excel MVP
> >> Tutorials and Custom Solutions
> >> http://PeltierTech.com
> >> _______
> >>
> >>
> >>
> >>
>
>
>