Excel produces quarterly profit and current year profit Plan column chart method

Excel produces quarterly profit and current year profit Plan column chart method

There is an Excel form for this year's quarterly profit situation and this year's profit plan.

The following column chart you will definitely do, directly inserted on the line.

Let's compare the three season columns to the annual plan, and without a lot of discussion, would you make a column chart that would add up to three-quarter stacks and an annual plan? The following illustration shows:

Production steps:

1, modify the data source table. Insert 2 columns between each product and move the value of the annual plan to the right one cell.

2, select the modified table, insert stacked column chart.

3, select the inserted column Chart "annual Plan" series, right-click menu, click "Set data series format"