Log Axis numbering??

Dear all

thanks for all support and help you are offering

I have a little issue with log axis in Excel, related to the excel defaults in numbering the axis. Typically, you set the min and max on the grid and then excel shows 1, 100, 1000 etc i.e. multiples of 10. However, how can I only show upto say 300 not 1000 and display the 1, 2, 5, 10, 20, 50, 300 points for example? Maybe the image below can better exaplin what I mean. Both x and y axis are log scaled, but the numbers displayed are not the defaults and min and max on both axis are not the defaults

http://img207.imageshack.us/img207/1195/chart.jpg

You will need to create your own axis labels.

Plot the data on a normal xy-scatter chart. Converting the values to be plotted using the LOG function.

The data labels for the 2 additional series can be linked to the cells using a free addin
http://www.appspro.com/Utilities/ChartLabeler.htm