To fix the labels manually, click the data labels on the left side of the chart to select all
the labels. Click just the 1 label. This corresponds to the company name in cell G50.
While the 1 label is selected, with a solid line surrounding it, type
=’Sheet Name’!G50
and press Enter.
12.Repeat step 11 to change the 2 label to =’Sheet Name’!G49. Continue to replace all the
labels.
13.Resize the entire chart area so that it is taller than it is wide.
The final chart is shown in Figure 7.30.
7
Fixing the labels remains a tedious process.You could switch to VBA or use Rob Bovey’s add-in.
Youcould also use the method described ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.