ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Excel - why use a logarithmic scale in a chart? (https://www.excelbanter.com/charts-charting-excel/261096-excel-why-use-logarithmic-scale-chart.html)

Polly

Excel - why use a logarithmic scale in a chart?
 
I understand how to change the scale on the value axis to logarithmic, I am
just not sure why I would do so.

Luke M[_4_]

Excel - why use a logarithmic scale in a chart?
 
Usually helpful when:
a) Trying to plot exponential series (such as in calculus, some physics,
etc)
b) Trying to distort data so your customers don't see how badly your company
is losing money *grin*

--
Best Regards,

Luke M
"Polly" wrote in message
...
I understand how to change the scale on the value axis to logarithmic, I am
just not sure why I would do so.




David Biddulph[_2_]

Excel - why use a logarithmic scale in a chart?
 
If in your chart you have some large numbers and use a linear scale, you
won't see differences in small numbers.
try, for example a series like
1
2
1.00E+05
2.00E+05
Plot the series on a linear scale (& see whether you can see the difference
between the first two points), then change it to log.
--
David Biddulph


"Polly" wrote in message
...
I understand how to change the scale on the value axis to logarithmic, I
am
just not sure why I would do so.





All times are GMT +1. The time now is 10:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com