![]() Now you need to add data labels to the data bars. Now you need to specify different colors for each main category.ġ2.3) Click on any one of the bars and then press the F4 key to apply the same outline color to all the bars.ġ3. Do the same to remove the horizontal axis and the gridlines.ġ0. Select the chart title and then press the Delete key to remove it from the chart. Click the vertical axis, go to the Format Axis pane, and then check the Categories in reverse order box.ĩ. Then you can see black outlines are added to the blank areas in the vertical axis fields.Ĩ. Double click the first cell of the first row of each pair of blank rows you have inserted in step 6, type in a blank space by pressing the Space key once in the keyboard. Then you can see categories and data bars in the chart are separated with blank spaces as well.ħ. Insert two blank rows before each main subcategory (except the first one) in the data range. In the Format Data Series pane, change the Gap Width to 50%.Ħ. Tips: You can also double click any of the bars to open the Format Data Series pane.ĥ. Right click the bar and select Format Data Series from the right-clicking menu to open the Format Data Series pane. Drag the chart border to enlarge the chart area. Select the data range, click Insert > Insert Column or Bar Chart > Clustered Bar.ģ. 1.3) In the third column, type in each data for the subcategories.Ģ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |