| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
how can I make a chart with the x-axis in logarithmic scale
how can I make a chart with the x-axis in logarithmic scale. the built in
function makes the y-axis log |
|
#2
|
|||
|
|||
|
Hi,
You need to use the xy scatter chart type if you want an x-axis log scale. Cheers Andy Doris wrote: how can I make a chart with the x-axis in logarithmic scale. the built in function makes the y-axis log -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
|
|||
|
|||
|
Where do I set log scale for x-axis on scatter plot
"Andy Pope" wrote: Hi, You need to use the xy scatter chart type if you want an x-axis log scale. Cheers Andy Doris wrote: how can I make a chart with the x-axis in logarithmic scale. the built in function makes the y-axis log -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#4
|
|||
|
|||
|
Double click the x axis. This should display the format dialog.
On the Scale tab is the option for Log scale (very similar to y axis method). Cheers Andy Doris wrote: Where do I set log scale for x-axis on scatter plot "Andy Pope" wrote: Hi, You need to use the xy scatter chart type if you want an x-axis log scale. Cheers Andy Doris wrote: how can I make a chart with the x-axis in logarithmic scale. the built in function makes the y-axis log -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#5
|
|||
|
|||
|
Never mind, I found it. Thanks so much
doris "Andy Pope" wrote: Hi, You need to use the xy scatter chart type if you want an x-axis log scale. Cheers Andy Doris wrote: how can I make a chart with the x-axis in logarithmic scale. the built in function makes the y-axis log -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I scale the axis of a chart from external data so that dis. | Charts and Charting in Excel | |||
| How do I set permanent secondary axis in PivotTable chart? | Charts and Charting in Excel | |||
| I want to produce a log-log chart. Logrithmic scale on both axis. | Charts and Charting in Excel | |||
| Second X axis at top of chart? | Charts and Charting in Excel | |||
| Labels on Chart with Negative Value Axis | Charts and Charting in Excel | |||
Hybrid Mode
