Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 16th 06, 06:21 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 1
Default How to draw chart: log scale on X axis, natural scale on y axis?

How to draw chart: log scale on X axis, natural scale on y axis? sample data
is given below. This chart is used for Civil Engineering?

X axis Y axis
Sieve size % passing
26 mm 100
22 mm 95
16 mm 81
12 mm 75
10 mm 66
4.8 mm 52
2.4 mm 42
1.2 mm 32
0.6 mm 18
0.3 mm 16
0.15 mm 9
0.09 mm 3


  #2   Report Post  
Old November 16th 06, 08:03 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 618
Default How to draw chart: log scale on X axis, natural scale on y axis?

Right-click on the X-axis, select Format Axis, choose the "Scale" tab, and
tick the "logarithmic scale" box.

You will, of course, need to be using the XY chart (confusingly named
scatter), rather than a line chart.
--
David Biddulph

"Pratap D. chavan" <Pratap D. wrote in
message ...
How to draw chart: log scale on X axis, natural scale on y axis? sample
data
is given below. This chart is used for Civil Engineering?

X axis Y axis
Sieve size % passing
26 mm 100
22 mm 95
16 mm 81
12 mm 75
10 mm 66
4.8 mm 52
2.4 mm 42
1.2 mm 32
0.6 mm 18
0.3 mm 16
0.15 mm 9
0.09 mm 3





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chaning X axis scale in Excel 2003 wendythelwell Charts and Charting in Excel 2 August 9th 05 02:35 PM
XY scatter and Bar chart - secondary axis misaligned philcud Charts and Charting in Excel 3 August 8th 05 09:00 AM
XY scatter and Bar chart - secondary axis misaligned philcud Charts and Charting in Excel 0 August 3rd 05 04:02 PM
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
Labels on Chart with Negative Value Axis David F. Schrader Charts and Charting in Excel 6 December 17th 04 06:25 PM


All times are GMT +1. The time now is 04:51 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017