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.
- Press with left mouse button on the "Insert Column or Bar Chart" button open a menu.
- Press with left mouse button on 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.
- Press with right mouse button on on chart.
- Press with left mouse button on "Select Data..."
- Press with left mouse button on the "arrow" button to select a new chart data range.
- Select the data.
The chart changes to something like this.
Get Excel *.xlsx file
Weekly Blog EMAIL
[newsletter_signup_form id=1]
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
This article demonstrates how to sort a data set by multipe columns using the SORTBY function, Ecel Table and Excel […]
Highlight a column in a stacked column chart
I discovered this chart from Google Public policy blog and it got me thinking if I could do the same […]
Split search value using delimiter and search for each substring
This article demonstrates formulas and a UDF that searches for values in a table based on concatenated values and returns […]
How to use the MAXIFS function
The MAXIFS function returns the largest number based on a condition or criteria. The MAXIFS function was introduced in Excel […]
The IPMT function calculates the interest payment for a specific period for an investment based on repeated constant payments and a […]
How to create a 100% stacked column chart
The 100% stacked column chart lets you graph values in a group. Each value in a group is a stacked […]
To be able to resize a chart you must first select it, you do that by press with left mouse button […]
The image above shows lines between each colored column, here is how to add them automatically to your chart. Select […]
This trick is so simple and also an incredible time-saver if you want to build beautiful worksheets or dashboards where […]
Question: How do I create a chart that dynamically adds the values, as i type them on the worksheet? Answer: […]
Fatou asks: Going back to my question, I had created a table and used the data to create a chart. […]
Slicers let you control data displayed in a chart, simply press with left mouse button on a button to quickly […]
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.
