Highlight the whole spreadsheet again, but this time with the revenue row.Įxcel has automatically expanded the value domain in Y-axis, therefore the data on sales volume are at the very bottom in the form of inconspicuous columns. You will see a field offering to choose a different interval. Click on the empty area and select: «CHART TOOLS»-«DESIGN»-«Select Data». To begin with, add to the spreadsheet one more row containing monthly revenue. Some data arrays imply making more complicated charts combining several types, for example, a column chart and a line. How to combine a column with a line chart in Excel? Similarly, we can make other changes to the graph. As a result, we have almost the same column with Y axis reflecting percentage correlations Let’s change the stacked column to the normalized one. If you right-click on the empty area of the chart and select «Change Type» (OR select: «CHART TOOLS»-«DESIGN»-«Change Chart Type») you can modify it a bit.
We have obtained a chart showing that, for example, in January, milk sales were higher than those of yogurt and cream while in August a small amount of milk was sold compared to other products, and so on.Ĭolumn charts in Excel can be changed. It is created in the similar way, but a different type should be chosen. It is another column chart type allowing us to present data in percentage correlation. Let’s consider making a stacked column chart in Excel.
0 kommentar(er)
