Adding a trendline in excel 2016 for mac

broken image
broken image

But it has to be values otherwise colors won’t appear.

broken image

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.