View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Is Logarithmic the way to go?

Logrithmic tends to distort the graph and often gives the user a false
impression of what is going on. What will probably work better for you is to
place one of the data seris on a secondary axis.

Right click on one of the data seris and select Format Data Series... In the
dialog Select the Axis tab and choose Secondary. The two seris will now be
plotted on their own seperate axis.
--
HTH...

Jim Thomlinson


"Arlen" wrote:

I am trying to chart two different statistics on one chart. One statistic
ranges from 0 to 10, the other is typically over 10000.

Because of the wide discrepancy, I am using Logarithmic scale so both plots
are visible, however, I also have a lot of Zero values and Logarithm Scale
has a problem with that. How do I get around this? It's hard to find the
words to ask the MS Paperclip.

Thanks for any help.

Arlen