ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   can I draw a semi log graph using exel 2000? (https://www.excelbanter.com/excel-discussion-misc-queries/76855-can-i-draw-semi-log-graph-using-exel-2000-a.html)

sara

can I draw a semi log graph using exel 2000?
 
can I draw a semi log graph using exel 2000? ( for example changing the x
axis )

hmm

can I draw a semi log graph using exel 2000?
 
Right-click on the x-axis, choose "Format Axis." In "Scale," check the box
"Logarithmic Scale," then OK. You will have a graph with a logarithmic
x-axis and linear y-axis (semi-log).

Incidentally, Excel will point out to you (over and over again!) if any
logarthimically-plotted values are zero or negative, or if the minimum of the
axis scale is set to zero or below.

"sara" wrote:

can I draw a semi log graph using exel 2000? ( for example changing the x
axis )


Mike Middleton

can I draw a semi log graph using exel 2000?
 
sara -

The only Excel chart type that allows a logarithmic X axis is the XY
(Scatter) chart type.

- Mike
www.mikemiddleton.com

"sara" wrote in message
...
can I draw a semi log graph using exel 2000? ( for example changing the x
axis )





All times are GMT +1. The time now is 12:47 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com