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
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.
English
Spanish
