Is Logarithmic the way to go?

[Arlen]

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

 

[Jim Thomlinson]

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.

 

[ldiaz]

I think you can chart these two statics using a secondayy axis,


Select values in chart, then with the right button select Format Data
Series...
select Axis tab, then click on the Secondary Axis.

Thanks

 

[Arlen]

Hey, that's excellent. Now, I'm wondering, how do I actually make these two
plots sit next to each other. When I do the Secondary Axis thing, one
overlaps the other. I played with Gap Width and Spacing and everything.
Fruitless, I say.

Thanks again.

Arlen

 

[Jim Thomlinson]

I'm lost as to what you want exactly. That being said here is an excellent
resource on all things to do with graphs...

http://peltiertech.com/Excel/Charts/index.html