Thread: Changing the x-axis values on a logarithmic chart?

Hi,

I'm trying to plot some aggregate compositions in Excel 2003.

The plot works shows the correct y-values, but I need to change the x-axis. The x-axis is logarithmic (x,y-scatterplot) and instead of showing 0.01, 0.1, 1, 100 as x-axis values I need it to show the actual plotted values.

In the attached file the right handside graph shows what I want but it's made with tekstboxes and if I need to change the x-axis values then that obviously won't work.

The lefthandside graph plots the values correctly but doesn't show the x-axis values as needed. I don't need any other values on the x-axis.

Any ideas?

/Møller

why not using data labels X-values. The grid lines are done on Chart options Gridlines.

Originally Posted by rwgrietveld

why not using data labels X-values. The grid lines are done on Chart options Gridlines.

That doesn't show the x-value on the axis.

/Møller

You will need to build the chart your self using dummy data series to create axis.

You can find more information at these sites.
http://peltiertech.com/Excel/Charts/RecipAxisChart.html
http://www.tushar-mehta.com/excel/ne...ale/index.html

I found a workaround.

If I add an extra x,y set with the x-axis values as needed and y=0, I can then
a) show the x-value (below the x-axis).
b) add a an error bar from 0-100 that.

Easy :-)

/Møller