Group chart categories
The image above shows you categories (countries) grouped into regions making this chart a lot cleaner and easier to read.
How to construct
This image shows the countries in a simple column chart without groups and the data used to build the chart. Follow these steps to group the categories (countries).
- Insert a new column before the Category column (Country).
Column B contains the group names, however, they are located at the very first category (country) name and there is only one instance. - Select the data.
- Go to tab "Insert" on the ribbon.
- Click the "Insert Column or Bar Chart" button open a menu.
- Click the "Clustered Column Chart" button.
- Change the chart title, resize the chart so the category names may fit the chart area without being rotated if you prefer.
Adjust chart data range
If you already have a chart created you simply need to change the chart data source.
- Right click on chart.
- Click "Select Data..."
- Click the "arrow" button to select a new chart data range.
- Select the data.
The chart changes to something like this.
Download Excel *.xlsx file
Weekly Blog EMAIL
Welcome! I am Oscar and here to help you out.Feel free to comment and ask Excel questions.
Make sure you subscribe to my newsletter so you don't miss new blog articles.
Related articles
Question: How do I create a chart that dynamically adds the values, as i type them on the worksheet? Answer: […]
Rearrange data source in order to create a dynamic chart
Fatou asks: Going back to my question, I had created a table and used the data to create a chart. […]
How to add lines between stacked columns/bars [Excel charts]
The image above shows lines between each colored column, here is how to add them automatically to your chart. Select […]
Use slicers to quickly filter chart data
Slicers let you control data displayed in a chart, simply click on a button to quickly filter data. How to […]
How to align chart with cell grid
This trick is so simple and also an incredible time-saver if you want to build beautiful worksheets or dashboards where […]
To be able to resize a chart you must first select it, you do that by left-click on the chart with […]
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
