Hello, All!

I hope this is not a FAQ but I have not been able to think of a
suitable search phrase. In one particular chart, I find it
convenient to have the y-axis on the *right* for quick reference
to the latest values. I know how to do that by adjusting the
crossing value (following Jon Peltier's instructions for an
x-axis) but the scale then appears *inside* the chart area not
outside where I would like it. If the axis were a secondary
axis, the scale would be positioned as I want it but I don't
think you can have a secondary axis without a primary, can you?
Again, to have identical primary *and* secondary axes might be a
possibility and even desirable but is this possible?

Thanks in advance.


James Silverton
Potomac, Maryland, USA

Hi,

Double click the x axis and on the scale tab check Value (Y) axis
crosses at maximum category.

James Silverton wrote:
Hello, All!

I hope this is not a FAQ but I have not been able to think of a suitable
search phrase. In one particular chart, I find it convenient to have the
y-axis on the *right* for quick reference to the latest values. I know
how to do that by adjusting the crossing value (following Jon Peltier's
instructions for an x-axis) but the scale then appears *inside* the
chart area not outside where I would like it. If the axis were a
secondary axis, the scale would be positioned as I want it but I don't
think you can have a secondary axis without a primary, can you? Again,
to have identical primary *and* secondary axes might be a possibility
and even desirable but is this possible?

Thanks in advance.


James Silverton
Potomac, Maryland, USA

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Andy wrote on Sat, 19 Nov 2005 15:32:49 +0000:

AP Double click the x axis and on the scale tab check Value
AP (Y) axis crosses at maximum category.

AP James Silverton wrote:
?? Hello, All!
??
?? I hope this is not a FAQ but I have not been able to think
?? of a suitable search phrase. In one particular chart, I
?? find it convenient to have the y-axis on the *right* for
?? quick reference to the latest values. I know how to do
?? that by adjusting the crossing value (following Jon
?? Peltier's instructions for an x-axis) but the scale then
?? appears *inside* the chart area not outside where I would
?? like it. If the axis were a secondary axis, the scale
?? would be positioned as I want it but I don't think you can
?? have a secondary axis without a primary, can you? Again,
?? to have identical primary *and* secondary axes might be a
?? possibility and even desirable but is this possible?

Thanks, that is essentially what Jon Peltier suggested, tho for
the y-axis I used a crossing value much larger than can
anticipated. However the problem of the placing of the *scale*
remains, which appears to the *left* of the markers; in other
words on the graph.

James Silverton.

James wrote to Andy Pope on Sat, 19 Nov 2005 13:53:11 -0500:

AP Double click the x axis and on the scale tab check Value
AP (Y) axis crosses at maximum category.

AP James Silverton wrote (and was wrong.....JVS! )

Thank you Andy, that does exactly what I wanted with the scale
to the right. The prescription I was using is correct for
placing the x-axis at the bottom of a chart since there is no
choice to get the x-axis to cross at a minimum. Sorry about the
far too quick and wrong reply.

James Silverton.