Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
semilog graphing and excel
I am trying to make a semi-log graph with very small numbers for the x -axis
x=.01 x=.030303 x=.05 my y values are in the range from .2 to 1.1 excel makes the semilog graph for these values extremely small and will not allow me to make my minor grid marks small enough to be appropriate for the x axis values. I also get many warning saying i cant use a number less than zero.. Any suggestions Does the log trendline function of Excel work with these small numbers? if i converted my data by multiplying by 1000 on all data points would the out put still be similar... -- dr chuck |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
semilog graphing and excel
I make a perfectly acceptable chart form
x y 0.01 0.2 0.03 0.7 0.05 1.1 with x-axis logarithmic. What was your problem? I added a trend line. Since the definition of log excludes any reference to negative values, you cannot fault Excel for not being able to handle log(x) with x < 0. best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "dr chuck" wrote in message ... I am trying to make a semi-log graph with very small numbers for the x -axis x=.01 x=.030303 x=.05 my y values are in the range from .2 to 1.1 excel makes the semilog graph for these values extremely small and will not allow me to make my minor grid marks small enough to be appropriate for the x axis values. I also get many warning saying i cant use a number less than zero.. Any suggestions Does the log trendline function of Excel work with these small numbers? if i converted my data by multiplying by 1000 on all data points would the out put still be similar... -- dr chuck |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Graphing errors in excel | Charts and Charting in Excel | |||
MS EXCEL graphing | Excel Discussion (Misc queries) | |||
semilog graph paper | Charts and Charting in Excel | |||
How to use just the graphing capabilities of MS Excel? | Excel Discussion (Misc queries) | |||
do we have semilog paper | Excel Worksheet Functions |