![microsoft excel for mac 2011 combo chart microsoft excel for mac 2011 combo chart](https://cdn.ablebits.com/_img-blog/excel-chart-tips/excel-chart-patternfill.png)
- #Microsoft excel for mac 2011 combo chart how to#
- #Microsoft excel for mac 2011 combo chart series#
- #Microsoft excel for mac 2011 combo chart free#
Obviously, if you have your own data, please feel free to use it. We are using publicly available UK government data.
#Microsoft excel for mac 2011 combo chart how to#
Here's how to make good graphs in Excel-even for boring financial spreadsheets. However, we can make this right for you now. Remember the graphs you made in Excel when you were nine? Exactly! Comic Sans in lime-green is not the way to go.
![microsoft excel for mac 2011 combo chart microsoft excel for mac 2011 combo chart](https://www.exceldashboardtemplates.com/wp-content/uploads/2014/06/image17.png)
Taking numerical concepts and displaying them visually can make all the difference in whether someone grasps your idea or not.Ĭharts and graphs do not need to be complicated.
#Microsoft excel for mac 2011 combo chart series#
We just changed the font color of the axes labels to match the color of the series as shown in Figure 8, below (compare with Figure 7).The power of a good graph is undeniable. With just two series, this is an easy problem to solve. Look closely at Figure 7 again, and you will realize that there’s no easy way to identify if a particular series uses the primary or the secondary axis.You cannot compare apples and oranges, but they can still co-exist! Creating a combination chart of this type with two series makes your data appear so much better, and it also ends up being so much easier on the eye for your audience.In Figure 7, below you can see that the series representing rainfall has changed to a Marked Line.įigure 7: Chart type changed for the selected series This action changes the selected series to the new chart type.They only make an appearance when you are working with a particular slide object which can be edited using special options. These tabs are special tabs in the Ribbon that are not visible all the time. The Chart Layout and Format are contextual tabs.We chose the Marked Line chart type (refer to Figure 6 again).įigure 6: Choose a new chart type for the selected series Choose a new chart type for the selected series and click on it. Doing so activates the Charts tab on the Ribbon and makes all Chart Types visible as shown in Figure 6, below.From the context menu, choose the Change Series Chart Type option (refer to Figure 5 again).įigure 5: Change the chart type of selected series Select the series that you want to change the type of, and right-click (or Ctrl+click) to access the context menu, as shown in Figure 5, below. To solve this problem, you need to change the chart type of any one of the series.Columns depicting rainfall are completely hiding most of the columns representing the average temperature We might have solved the problem of comprehending the actual values better now, but we have a new problem to solve! As you can see in Figure 4 above, one data series is overlapping the other.The primary value axis displays minimum and maximum values between 0.0 and 14.0 and the secondary value axis spans a completely different range between 0 and 80. Note that axis labels on both the value axes show different numbered ranges. This step adds a secondary value axis that maps your selected series, as shown in Figure 4, below.Next select the radio button in front of the Secondary axis option, as shown highlighted in red within Figure 3.įigure 3: Secondary axis option selected for one of the series In this dialog box, select the Axis option within the sidebar. Doing so summons the Format Data Series dialog box that you can see in Figure 3, below.From the contextual menu, choose the Format Data Series option (refer to Figure 2 again).įigure 2: Format Data Series option selected Right-click (or Ctrl+click) this series to access the contextual menu, as shown in Figure 2, below.
![microsoft excel for mac 2011 combo chart microsoft excel for mac 2011 combo chart](https://i.ytimg.com/vi/99XaQFINf_Q/maxresdefault.jpg)
Within the chart, select the series to which you want to add a second value axis.