• Create Account

# Drawing this Graph with wide values?!

3 replies to this topic

### #1 .Bioforum.

.Bioforum.

member

• Active Members
• 7 posts
0
Neutral

Posted 16 March 2011 - 05:53 PM

My values are:-

x-axis(time): 0, 1, 3, 7
y-axis(colonies): 2890000, 8910000, 13000, 450, 50, 1700
(there are more of these but this includes the highest and lowest values!)

I can't figure out how to contruct the divisions on y-axis!! Please help!

(I can't do any log graphs for this. So, I'm currently doing this in Microsoft Excel and its producing a useless huge graph where i can't see the values! The numbers are spread so hugely that the graph ignores small values. But I'm sure there's a way to construct it nicely. Hence, require your help please.)

### #2 HomeBrew

HomeBrew

Veteran

• Global Moderators
• 927 posts
14
Good

Posted 16 March 2011 - 06:12 PM

Is this a graph of bacterial death?  Can you plot them as percent remaining, using 2890000 as 100%?

### #3 K.B.

K.B.

Veteran

• Active Members
• 174 posts
3
Neutral

Posted 16 March 2011 - 11:34 PM

I see two solutions - logarithmic scale or 2~3 segment Y-axis (eg. 0-2000, 10000-20000, 1000000-10000000).

### #4 pito

pito

Veteran

• Active Members
• 1,022 posts
51
Excellent

Posted 19 March 2011 - 12:34 AM

Not an answer, but a question:

are those numbers from the same dilution? Or from different ones?

If its option 2: put each dilution on its own graph.
If you don't know it, then ask it! Better to ask and look foolish to some then not ask and stay stupid.