Excel graph - semi log help

Sac Arrow

Sac Arrow

Touchdown! Greaser!
Joined
May 11, 2010
Messages
20,333
Location
Charlotte, NC
Display Name
Display name:
Snorting his way across the USA
For some reason, I cannot force Excel to make a semi log plot on the Y axis. I have the option on the X axis. I do not have the option on the Y axis. I've tried switching the time plot to straight numbers, no dice. Google fu is failing. Any ideas?
 
The option is there for me when I right click on the vertical axis. I have whatever the latest version is that comes with Office 365. Otherwise, IDK.

semi-log.PNG
 
Sorry, I mean the horizontal axis. Dyslexic here. The option is there for the vertical axis.
 
I see what you mean...in a line chart. I changed mine to a scatter plot. and the logarithmic option is there for the horizontal axis too.
 
Van Johnston said:
I see what you mean...in a line chart. I changed mine to a scatter plot. and the logarithmic option is there for the horizontal axis too.
Click to expand...

Hmm, good to know. The data is bad anyway so I'm not going to bother.
 
Sac Arrow said:
Hmm, good to know. The data is bad anyway so I'm not going to bother.
Click to expand...
But if you make it really pretty hardly anyone will notice. :)

Or so it seems in my experience...
 
You must log in or register to reply here.
Back
Top