If you change the name in cell A9, the formulas will update to display the figures for the new name. Note that the formula in cells B9-M9 uses the Excel Column and the Excel Vlookup functions to look up the data for the name in cell A9. 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.
