Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
In the x axis, logarithmic scale
As previously reported, I used scatter chart. However, my data are bellow 1
(0.1; 0.5) and my y axis is in the middle of the chart. How can I put Y axis on the left keeping these values? Thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
In the x axis, logarithmic scale
Charles -
To change the location of the Y axis on an XY (Scatter) chart, select the horizontal X axis, choose Format Selected Axis | Scale, uncheck the box for "Value (Y) Axis Crosses At," and specify an X value. - Mike www.mikemiddleton.com "Charles" wrote in message ... As previously reported, I used scatter chart. However, my data are bellow 1 (0.1; 0.5) and my y axis is in the middle of the chart. How can I put Y axis on the left keeping these values? Thanks |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
In the x axis, logarithmic scale
Charles -
For a log X axis of an XY (Scatter) chart, on the Format Axis | Scale tab, you should specify both the "Minimum" value and the "Value (Y) Axis Crosses At" value. Also, Excel will use only multiples of 10 on the log X axis. So, for example, you might specify 0.01 or 0.001. - Mike www.mikemiddleton.com "Mike Middleton" wrote in message ... Charles - To change the location of the Y axis on an XY (Scatter) chart, select the horizontal X axis, choose Format Selected Axis | Scale, uncheck the box for "Value (Y) Axis Crosses At," and specify an X value. - Mike www.mikemiddleton.com "Charles" wrote in message ... As previously reported, I used scatter chart. However, my data are bellow 1 (0.1; 0.5) and my y axis is in the middle of the chart. How can I put Y axis on the left keeping these values? Thanks |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
In the x axis, logarithmic scale
"Charles" wrote in message
... As previously reported, I used scatter chart. However, my data are bellow 1 (0.1; 0.5) and my y axis is in the middle of the chart. How can I put Y axis on the left keeping these values? Right Click on the X-axis. Format Axis Scale Value (Y) axis crosses at: [choose which X value you want your Y axis; possibly your minimum X value?] -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
X axis scale on an XY scatter plot | Charts and Charting in Excel | |||
"X" Axis with different scale | Charts and Charting in Excel | |||
Chaning X axis scale in Excel 2003 | Charts and Charting in Excel | |||
"Scale breaks" required in (Z) axis | Charts and Charting in Excel | |||
Logarithmic Scale - Tic Label Disappearance | Charts and Charting in Excel |