That would affect the final look of the chart. In this case, select the cells from A1 to C1.ĭo not include the A4 cell in the Axis label range. Select the range of cells that include the labels for the chart. Under the Horizontal (Category) Axis Labels, press the Edit button. Under the Design tab, select the Select Data option. All that is left is to modify it into a half moon chart. In addition, the Chart Tools contextual tab will also appear every time you select a chart. It will only confuse Excel.įrom the Insert tab, select the first chart from the Pie category. Do not include the cells with the labels. Select only the cells with the values (from A2 to D2 in this case). It must always take half of the entire total. In this case, the D2 cell is the sum of A2 to C2 or =sum(a2:c2). It's a variation of a Pie chart.Įnter the values and the labels in the appropriate cells.Īt the end of the row, use the sum() function to have the total of all the values of the row. This page will show you how to make a half-moon chart.
0 kommentar(er)
