Sit back and have a coffee- well done!.Ī few chart types can’t be combined- for example a bubble chart or a 3D chart, but as usual with Excel of you try to choose an incompatible chart type it will let you know!. The example chart chart started out as a standard column chart an a few clicks later a smart and more appropriate combination chart is made. Choose an icon that you want to change the data series to.Click the series you want to change ( I am changing the sales targets- the third column of my data set). ![]() The first step is to create your chart with two data series as normal. Step 3 On the INSERT tab, in the Charts group, click the Combo chart icon on the Ribbon You will see the different types of available Combo charts. I have used the scenario of the targets (projected sales) and actual monthly sales for an example below. Step 1 Arrange the data in columns and rows on the worksheet. Combination charts are not available on the Excel ribbon (Excel 2007) This is where a combination chart is really useful. ![]() If my chart has more than one data series for example monthly targets and actual monthly sales, you may sometimes want to display these as multiple styles on the same chart. Typically most people create charts with one style such as a column chart, a line chart, or a pie chart.
0 Comments
Leave a Reply. |