Creating a chart with dynamic labels
The trick of this chart is to show data from specific cells in the chart labels. For example, if you have to show in one chart two different data bar:
- To compare two different teams, you should create a chart using percent of task completing (in this example, cells C17:D17).
- But it will be more informative to see the real volume for every team (in this example, cells C15:D15). Or the simple formulas:
Team A: =CONCATENATE(IF($C17>$D17,"Winner - ","Looser - "),TEXT(C15,"#.#0"))
Team B: =CONCATENATE(IF($C17<$D17,"Winner - ","Looser - "),TEXT(D15,"#.#0"))
For the existing chart, do the following:
1. Right-click on the data series and then in the popup menu select Add Data Label and again Add Data Label:
2. Do one of the following:
- For all labels: on the Format Data Labels task pane, in the Label Options, in the Label Contains group, check Value From Cells and then choose cells:
- For the specific label: double-click on the label value, in the popup menu select Choose Cell and then specify the value:
Make any other adjustments to get the look you desire.
Permission is granted for article quotations from OfficeToolTips, provided the direct link to the source articlehttp://www.officetooltips.com/excel 2016/tips/creating a chart with dynamic labels.html