...
Right click the graph legend and choose choose Legend: Update Legend... from the context menu. This opens the legendupdate dialog box. When the Auto Legend Translation Mode is set to Custom, the Legend Custom Format control combo box now
- provides a
...
- dropdown list populated with some substitution notation examples, such as @WM (worksheet comment); @WS_@LL, (Sheetname_ColumnLongName), etc.
- > button next to the combo box with common substitution notations and explanations. Every time user selects one, it will be appended to the end of the current format. This provides an easy way for user to choose useful info and then customize further.
Note: User can press F1 and then see more substitution notations in Help.
More Legend Update Modes on Legends/Title Tab
...