Рет қаралды 291
We cover how to create a stacked and clustered combination chart in Excel. This type of chart is very useful if you want to visualise a multi-dimensional dataset in a digestible way. In our example, we have the global sales of two products across 4 quarters. We also show the breakdown of how much is coming from the US for each product in each quarter. We want to show how much of the sales is coming from the US within the overall global figure and include this in the same bar.
Subscribe for weekly Excel tutorials, techniques and examples:
/ @theexcelhub
Please share this video with others that may find it useful:
• Stacked & Clustered Co...
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
🌍 The Excel Hub website: theexcelhub.com/
📸 Instagram: / theexcelhub
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
theexcelhub@outlook.com
Overview: (0:00)
Insert chart: (0:47)
Adjust axes: (1:29)
Format chart: (3:23)