EXCEL ADD AXIS TITLES TO A CHART SERIES

This problem can be remedied by creating a second vertical axis that shows the values associated with the activity hours. As a result, the activity totalsВ are atВ the bottom of the chart with the TotalВ CaloriesВ ConsumedВ at the top. The chart now shows theВ Total Calories Consumed data as a line.В These totals are much more than the activity totals, and the values on the vertical axis represent this. Click OK to close the dialog box and apply the change. On the Design contextual tab, in the Type group, click Change Chart Type.

EXCEL ADD AXIS TITLES TO A CHART SERIES

To begin changing theВ Total Calories Consumed data series to a line chart, select theВ Total Calories Consumed column. 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.

Excel add axis titles to a chart