Transfer the revenue data to the right side. However, this histogram is incorrect as it contains numbers expressed both and in quantity (liters). 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.
ADD SECOND Y AXIS IN EXCEL 2016 FOR MAC HOW TO
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)
