To format the font, color and size of the label, now right-click on the label and select ‘ Font‘.
series name, category name, value, leader line), the position (right, left, above, below) in the Format Data Label pane/dialog box.
Note: the code can be copied from here and pasted into a regular code module. Text = 10 & WorksheetFunction.Log10(vYVals(iPt)) DataLabels.Position = xlLabelPositionLeft VXVals(iPt) = cht.Axes(xlCategory).MinimumScale IMax = WorksheetFunction.Log10(cht.Axes(xlValue).MaximumScale)
' VERTICAL AXIS -Ĭht.Axes(xlValue).TickLabels.NumberFormat = "_0_0_0_0_0_0_0" ' hide but maintain margin Text = 10 & WorksheetFunction.Log10(vXVals(iPt)) DataLabels.Position = xlLabelPositionBelow ' add series, hide points, add and format labels VYVals(iPt) = cht.Axes(xlValue).MinimumScale IMax = WorksheetFunction.Log10(cht.Axes(xlCategory).MaximumScale) IMin = WorksheetFunction.Log10(cht.Axes(xlCategory).MinimumScale) ' HORIZONTAL AXIS -Ĭht.Axes(xlCategory).TickLabels.NumberFormat = " " ' hide tick labels Sub NiceExponentialAxisLabels()ĭim iPt As Long, iLog As Long, iMin As Long, iMax As Long Select a log-log plot with axes on its left and bottom edges, and run the code below. And this is a pain to do by hand, because it's hard to select the exponents and apply the formatting, among other hard things. Hide these points, and add data labels, put in 101, 102, etc (for 10^1, 10^2, etc), and format the exponent to be superscripted. So the approach is to add dummy series along each axis, at the places you want an axis label.
You'll need to do a fair bit of manual formatting work, as Excel doesn't have the number format you want.