PC Review


Reply
Thread Tools Rate Thread

How to draw chart: log scale on X axis, natural scale on y axis?

 
 
=?Utf-8?B?UHJhdGFwIEQuIGNoYXZhbg==?=
Guest
Posts: n/a
 
      16th Nov 2006
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 With Quote
 
 
 
 
David Biddulph
Guest
Posts: n/a
 
      16th Nov 2006
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. (E-Mail Removed)> wrote in
message news:8B1A5132-DDA8-4D20-8B48-(E-Mail Removed)...
> 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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Scale on X & Y Axis of the scatter chart chanyke Microsoft Excel Charting 3 28th Apr 2006 02:01 AM
Scale For Secondary Axis of Chart =?Utf-8?B?SnVzdGlu?= Microsoft Access VBA Modules 2 24th Jul 2005 07:02 AM
How to insert X axis scale values next to axis and X axis grid lin =?Utf-8?B?dnAyM2xhcnJ5?= Microsoft Excel Charting 2 23rd Jun 2005 03:45 PM
How do I scale the y axis on a bar chart in Excel? =?Utf-8?B?UmFjaGVsIEU=?= Microsoft Excel Charting 2 24th Nov 2004 02:46 PM
Custom X-Axis Scale for Chart Thom Microsoft Excel Charting 1 26th Jul 2003 01:22 AM


Features
 

Advertising
 

Newsgroups
 


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