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

Preguntas similare

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
Respuesta Responder a este mensaje
#2 jalvarez
29/03/2005 - 02:53 | Informe spam
KL:
Gracias por la intención deanalizar el problema, pero es un poco más profundo.
No veo cómo hacer para que en un gráfico logarítmico, establecer como valor
de "y" máximo, uno dado diferente a 10,100, 1000, etc. Parece que Excel
impone las potencias de 10 como valores máximos "forzados". Lo descripto en
tu respuesta funciona para un gráfico de escala lineal, no para una
logarítmica.
Se me ocurrió preguntar al foro sobre si hay algún "trick" que me permita
hacerlo.No se puede hasta ahora...
Saludos
Jalvarez

"KL" escribió:

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



Respuesta Responder a este mensaje
#3 KL
29/03/2005 - 07:44 | Informe spam
Hola Jalvarez,

Si me envias la hoja a mi correo electronico (
quitando NOSPAM y PLEASE ), mirare que se
puede hacer.

Saludos,
KL

"jalvarez" wrote in message
news:
KL:
Gracias por la intención deanalizar el problema, pero es un poco más
profundo.
No veo cómo hacer para que en un gráfico logarítmico, establecer como
valor
de "y" máximo, uno dado diferente a 10,100, 1000, etc. Parece que Excel
impone las potencias de 10 como valores máximos "forzados". Lo descripto
en
tu respuesta funciona para un gráfico de escala lineal, no para una
logarítmica.
Se me ocurrió preguntar al foro sobre si hay algún "trick" que me permita
hacerlo.No se puede hasta ahora...
Saludos
Jalvarez

"KL" escribió:

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



Respuesta Responder a este mensaje
#4 KL
29/03/2005 - 07:56 | Informe spam
Otra cosa. ?Has mirado aqui?:

http://www.contextures.com/JPChartIndex.htm
http://www.contextures.com/charts.html

Saludos,
KL


"KL" wrote in message
news:
Hola Jalvarez,

Si me envias la hoja a mi correo electronico (
quitando NOSPAM y PLEASE ), mirare que
se puede hacer.

Saludos,
KL

"jalvarez" wrote in message
news:
KL:
Gracias por la intención deanalizar el problema, pero es un poco más
profundo.
No veo cómo hacer para que en un gráfico logarítmico, establecer como
valor
de "y" máximo, uno dado diferente a 10,100, 1000, etc. Parece que Excel
impone las potencias de 10 como valores máximos "forzados". Lo descripto
en
tu respuesta funciona para un gráfico de escala lineal, no para una
logarítmica.
Se me ocurrió preguntar al foro sobre si hay algún "trick" que me permita
hacerlo.No se puede hasta ahora...
Saludos
Jalvarez

"KL" escribió:

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









email Siga el debate Respuesta Responder a este mensaje
Ads by Google
Help Hacer una preguntaRespuesta Tengo una respuesta
Search Busqueda sugerida