You can see how all the above Charts are made using the Sample Data File Attached If you setup a fancy Custom number Format as sayĪnd then set the axis scaling as Minimum 10, Major Unit 20, the two number 80 and 100, from the Custom format will not display as Excel will skip them according to the Axis Scale. Put the custom format in the Format Code dialog and Add Select the Chart and then the Axis or Data Point Labels. This technique can be extended in a number of areas Highlight Just a Single scoreĬustom Format: ”%”0 ”P”0 Using Wing Ding, Web Dings and Other CharactersĬustom Format: ”4″ ”8″ Ĭustom Format: ”P” ”O” Īs with cells you can apply custom Number formats to any of the Charts numerical objects including the Charts Axis and Data Point Labels.ġ.
WHAT ELSE CAN I DO WITH CUSTOM NUMBER FORMATS AND CHARTS “£ “0 means, Display a £ and a space in front of the number with no decimalsĠ means, Display the number with no decimals That Simple Custom Number format tells excel to apply at custom format of “£ “0 when the value is 80, otherwise use a normal 0 custom format. This involved a simple Custom Number Format being applied to the Y Axis, Number Format of the Chart. John wanted a chart with only the 80 highlighted as £80 and the rest of the axis as normal 10, 20 etc
0 kommentar(er)
