The above steps would give you a chart that has revenue and profit margin plotted as a clustered column chart.
With the Chart Selected, go to the Design tab and click on Select Data.
This will insert the chart in the worksheet area. In the Charts group, click on the ‘Insert Column Chart’ icon.Select the Revenue and Profit Margin data (B1:C6 in this example).To create this combination chart, I first need to create a regular chart where I have all the above data plotted on it.īelow are the steps to create a regular chart using the above data (the snapshots are of Excel 2016): Suppose I have the data set as shown below and I want to plot both the revenue and profit margin numbers in the same chart. Creating a Combination Chart in Excel 2013/2016 By adding a secondary Y-axis, we can plot the profit margin numbers separately (and still be able to plot both in the same chart). You can see that a revenue number are in thousands and are way higher than the profit margin numbers (which is in %). But with combination charts, you can have two Y-axis, which allows you to have two different type of data points in the same chart.įor example, you may be interested in plotting the annual revenue numbers of a company, and at the same time, also be able to show how the profit margin has changed.Ī combination chart (as shown below) is a good way of doing this in Excel. When you create a regular chart in Excel, it usually has only one X-axis and one Y-axis. For example, can quickly and easily emphasize the most unique methods of data distribution such as the mean (average), quartiles, median, and percentile groupings, and it can identify outliers.īox & Whisker is best for comparing characteristics between different sets of data, as opposed to Histogram and Pareto, which only provide visuals for one dataset.Combination charts in Excel let you present and compare two different data-sets that are related to each other (in a single chart). The Box & Whisker chart (like the Histogram chart) shows the distribution of information, but this chart delves much deeper into analysis. Once you’re satisfied with your changes, click the X to close the panel.Ġ10 Select and modify the Sunburst chart Format Data Series options. Click the Series Options down-arrow and browse through the menu choices: Chart Area, Chart Title, Data Labels, Legend, Plot Area, and Series. In the Format Data Series pane, click Series Options (the chart icon). Right-click any of the rectangles on the chart and select Format Data Series.Ĥ.
0 kommentar(er)
