Number Format:Can you please help how to do this?

[int555]

Hi all

I'm trying to change the format of numbers in a log-scale chart so that they appear as 10^x e.g. 10^3 rather than 1000 or 1E+03 or 1E+3..etc as in this image
\1
\1

Can you please help how to do this?

Warm thanks

[Andy Pope]

You will need to create you own axis labels and then use code to format them.
Note that Log axis will not allow zero or negative values.

Please Login or Register  to view this content.

[int555]

You will need to create you own axis labels and then use code to format them.
Note that Log axis will not allow zero or negative values.

[/code]

Thank you so much for your help, appreciated

Could you please tell me a little bit about how can I create my own code and formatting the axis, since I'm very new in this stuff.. All I do-usually- is use Excel functions..

Also, when I change the cells location in the attached file, the data points and axis scale change as well, is there a way to control this?

Warm thanks

[Andy Pope]

Well the code should handle most situations so not sure what you want in terms of 'your own code'.

Need more detail on what you mean by cell locations changing.

Do you need help on how to add the 2 extra series and format the axis to not display built-in values?

[int555]

Well the code should handle most situations so not sure what you want in terms of 'your own code'.

Need more detail on what you mean by cell locations changing.

Do you need help on how to add the 2 extra series and format the axis to not display built-in values?

I think I figured out how to change the labels..... just a quick question, how do I use the macro in Excel like the one you wrote?

[Andy Pope]

Open the workbook.
ALT+F11 (opens VBE [Visual Basic Editor])
Insert Module in to project
Paste code into module