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
Chart basics category
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 […]
Excel categories
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.