The activity hours are barely visible because they are much less than the total calories. The result shows us each activity, as well as the total calories, as columns. To create the initial column chart, on the Insert tab, in the Charts group, click Column, then click Clustered Column. To begin, we will select all of the data. We will create a combination chart that shows a column for each training activity and a line for the total calories. We can create a chart that shows the number of hours spent on each activity as well as the total number of calories consumed each week. Each week this person spends several hours running, biking and swimming. To create the combination chart, we will use the example of an athlete who is training for a triathalon. Combination charts are particularly helpful when the values of the data vary greatly or when you are working with mixed types of data.
Using a combination of a column chart and a line chart can give a more specific visual representation of the data and help to make data easier to understand. Combination charts can be used to highlight different types of information in a single chart.
