Logaritmic graphs, "y" axis with maximum different than ten power

18/03/2005 - 18:57 por Jorge Alvarez | Informe spam
I'm trying to make a graph in Excel limiting the maximum for the "y" axis to
a number different than 10; 100; 1000; 10000; etc.
Excel adjust the graph for the decade immediatly above the highest value of
the curve.
Is there a manner of correct this and obtain from Excel a graph where the
limits of the "y" axis can be handled, for example, between 300 (minimum) and
and 700 (maximum)?
Regards
 

Leer las respuestas

#1 KL
23/03/2005 - 02:08 | Informe spam
Hi Jorge,

The answer is yep, it is possible. Just right-click on the axis where you
want to modify the values and select 'Format Axis' from the popup menu. Then
go to the tab 'Scale' and make changes as needed. Make sure the 'Auto' box
is unchecked whereever you want to set the value manually. Voila!
Hope this helps.

Regards,
KL

"Jorge Alvarez" <Jorge wrote in message
news:
I'm trying to make a graph in Excel limiting the maximum for the "y" axis
to
a number different than 10; 100; 1000; 10000; etc.
Excel adjust the graph for the decade immediatly above the highest value
of
the curve.
Is there a manner of correct this and obtain from Excel a graph where the
limits of the "y" axis can be handled, for example, between 300 (minimum)
and
and 700 (maximum)?
Regards

Preguntas similares