But it has to be values otherwise colors won’t appear.
You have several options like series name, value from cells, category name. (Chart data is made-up) To apply custom format on data labels inside charts via custom number formatting, the data labels must be based on values. decimal: Example: data-graph-vline-name: th: Value displayed on the vertical line tooltip. Must be used with the data-graph-vline-x attribute. decimal: Example: data-graph-vline-height: th: Arbitrary draws a vertical line in the graph. Must be used with the data-graph-vline-height attribute. Arbitrary draws a vertical line in the graph. You can define colors in one of three ways: Manipulate the cross-hair and slider to pick a color. Click a blank color well under Custom to open the Colors dialog, and then go to Custom tab. Open the Color Chooser, then click on the Single tab.