How to change into hexadecimals the format code of a legend of a contour plot

[nrff]

I have created the spreadsheet attached, in which I plot my data using a contour plot. The legend of the contour plot is generated automatically by Excel. You can then select the axis format by doing the following:

-Click "Layout" under the "Chart Tools" tab
-Select "Vertical (Value) Axis) from the top left drop down menu
-Click "Format Selection" just below the above drop down menu
-in the "Format Axis" window that gets opened, go to "Number" and select "Custom"

Under "Format code" I would like to enter a format that will then show the hexadecimal version of the number being currently displayed in the legend.

so if say z is the actual number that get plotted, I would like the legend to display dec2hex(z).
So 15-20 will look like F-14

Unfortunately I cannot enter any functions in the "format code" so I was wondering if there is a way of specifying the format of the number to be hexadecimal.

Since Excel interprets the hex numbers as string, I cannot populated my cells with hex numbers and plot them, since they would be treated as text and not actual numbers.

[Andy Pope]

Best you can do is fake the legend using another chart object