Log Log Excel charts

[Tomei]

Hi,

Is it possible to have excel insert a chart that has BOTH the X axis AND the Y axis in log form?

Joe Tomei

 

[IRstuff]

Sure, are you having a problem with that? You'd need to select the scatter plot for the graph format. TTFN

 

[Tomei]

Yes I'm having trouble.

I can get a log y axis vs linear x axis but can't seem to get Log y & Log x.

How is that done?

Thanks

Joe

 

[IRstuff]

You need to select the x-y scatterplot.

You probably selected the line chart. The line chart only has a category x-axis, not a numerical x-axis. TTFN

 

[Rjeffery]

Transform your formula to logY=MlogX+logB then you can use the line chart method

 

[GregLocock]

No you can't.

Do it and you'll find out why it doesn't work for XY data. Cheers

Greg Locock

 

[melone]

Who can't? Plotting with the XY scatter will allow for X and Y log scale.

 

[GregLocock]

You can't use a line chart as Rjeffery suggested, unless your data is already at logarithmcially equal intervals.

Cheers

Greg Locock

 

[Rjeffery]

GregLocock,

Sorry.

I left off the

Sorry.

 

[Tomei]

Gemtlemen,

Thanks.

I finally understand that the xy chart is fundamentally different from the line chart.

I tried the xy scatter chart, and there, it was duck soup.

Thanks for your help.

Joe Tomei