Formatting Y-Axis

Hello,

I have a chart with two series where the values of both series are very different. Lets say that the first series is in generally in thousands while the second series is in millions. The maximum Y-value of the chart is thus set to millions and the variation in the first series is invisible – the whole first series looks like a flat line.

A workaround is to display logarithms – I logarithm my series and display the values. However, now the Y-axis shows “6” instead of “1000000”. What is the number format string using which I can display “10^6” instead of just “6”. In other words, what is the format string that prepends “10^” to the Y-axis?

Many thanks,
Daniel