Creating a Single Bar Graph with Multiple Subdata in Excel: A Tech Support Guide

Creating a Single Bar Graph with Multiple Sub-Data in Excel: Tech Support Guide

In this article, we will guide you on how to create a single bar graph with multiple sub-data using Microsoft Excel. This technique is useful when you want to compare different categories and their respective sub-data in a clear and concise way.

Prerequisites

Before we begin, make sure you have the following:

• Microsoft Excel installed on your computer
• A dataset with at least four categories and their respective sub-data

Step 1: Prepare Your Data

First, ensure that your data is organized in Excel with the categories in one column and their respective sub-data in the adjacent columns. For instance:

 
 Config  Config1 Config2 Config3 Config4  Total
 110    10    25    30    45     110
 15     5     10    15     20     50
 37     12    23    35     48     118
 58     20    30    35     43     128
 
 

Step 2: Create a Single Bar Chart

Now, let's create a single bar chart that represents the total data for each configuration. Follow these steps:

1. Select the cells containing the total data (from the "Total" column in our example).
2. Go to the "Insert" tab in the ribbon and click on "Bar Chart" in the "Charts" group.
3. Select the "Clustered Bar Chart" style and click "OK".

Step 3: Add Sub-Data to the Chart

To add the sub-data to the chart, follow these steps:

4. Select the data range for the first sub-data (in our example, it's the "Config1" column).
5. Right-click on the chart and select "Select Data" from the context menu.
6. In the "Legend Entries (Series)" tab, click "Add" and enter a name for the series (e.g., "Config1").
7. Select the cells containing the first sub-data and click "OK".
8. Repeat steps 4 to 7 for the remaining sub-data columns.

Step 4: Customize the Chart

You can customize the chart by adding titles, labels, and formatting the bars. To do this:

8. Click on the chart to select it.
9. Go to the "Chart Design" tab in the ribbon and add a title and axis labels as needed.
10. To format the bars, go to the "Format Data Series" pane (click on a data series to select it) and choose the desired fill color and border.

In this article, we demonstrated how to create a single bar graph with multiple sub-data using Microsoft Excel. This technique can be useful when you want to compare different categories and their respective sub-data in a clear and concise way. By following the steps outlined above, you should be able to create a professional-looking chart that effectively represents your data.

References

• Create a chart in Excel
• Change the data source for a chart in Excel