资讯

If you want to add labels to the bubbles in an Excel bubble chart, you have to do it after you create the chart. Mary Ann Richardson explains what you need to do to add a data label to each bubble.
Right-click the pie chart and select "Add Data Labels." Labels appear on the chart segments showing their values. Right-click the chart again and select "Format Data Labels." A dialog box opens.
Excel offers a one-click option on its "Insert" menu to take data on a spreadsheet and render it in a visual aid format.
By adding a helper column and a simple conditional format rule, you can apply an alternating band scheme that expands to accommodate a group.