Tweet
Anyone know how to make an Excel graph that is log-log, but where one of the axises goes from 1-30 instead of 1-100.
JM
JM
-
Jon Miller-
I AM.CANADIAN
GENERATION 35: The first time you see this, copy it into your sig on any forum and add 1 to the generation. Social experiment. -
Nup.
Sorry Jon, I can get the log-log part happening, but I can't see any way to make it give me different values on the axis. Every time I try to format the axis to display (1 to 30) it automatically changes itself back again to (1 to 100).
Tried playing around with the major/minor markers too, but it seems to just ignore them on a log chart.I don't know what I am - Pekka -
Yeah, that is what I was having happen to me also. I have tried it a number of times.
JMJon Miller-
I AM.CANADIAN
GENERATION 35: The first time you see this, copy it into your sig on any forum and add 1 to the generation. Social experiment.Comment
-
upload the excel file and i'll try to tinker with itComment
-
Here's the graph. I might do what KH has suggested and plot everything gnuplot, but I would sort of prefer to not redo stuff.
Both Axises should be log.
Jon MillerJon Miller-
I AM.CANADIAN
GENERATION 35: The first time you see this, copy it into your sig on any forum and add 1 to the generation. Social experiment.Comment
-
In Excel 2007, I right clicked on the y-axis and set it to Logarithmic scale with a maximum value of 30..."The issue is there are still many people out there that use religion as a crutch for bigotry and hate. Like Ben."
Ben Kenobi: "That means I'm doing something right. "Comment
-
.Attached Files"The issue is there are still many people out there that use religion as a crutch for bigotry and hate. Like Ben."
Ben Kenobi: "That means I'm doing something right. "Comment
-
-
ah i think excel 2002 won't let you have logarithmic scales with non 10X valuesComment
-
Of course Asher has the latest version
I couldnt do it with an with earlier version either (thats why I use graphpad).We need seperate human-only games for MP/PBEM that dont include the over-simplifications required to have a good AI
If any man be thirsty, let him come unto me and drink. Vampire 7:37
Just one old soldiers opinion. E Tenebris Lux. Pax quaeritur bello.Comment
-
Perhaps I will download the 2007 Beta... what considerations do I need to consider?
JMJon Miller-
I AM.CANADIAN
GENERATION 35: The first time you see this, copy it into your sig on any forum and add 1 to the generation. Social experiment.Comment
Comment