EXCEL2010 Chart Making column target progress chart

The column goal Progress chart is generally used to express the comparison between the actual completed and set goals. This diagram is mainly through the column chart set series overlap to achieve, can be more intuitive and clear to see the actual progress achieved. Below, we will show you the specific method of production.

① start Excel2010, create a chart of course, there are data sources, I simply set up a regional sales table, select the table, click the menu bar-insert-Column chart--Clustered Column chart.

After the ② chart is inserted, you see a bar with blue and red columns, right-click the Red Column bar, and choose Format Data series from the right-click menu.

③ in the Series Options tab, the series overlaps to the right, to the overlapping type, 100%.

④ then click Format--color fill, we choose no color fill, so that the red column changes.

⑤ Select the Blue column, and then switch to the Layout tab. Click the Data Label button and set it inside the data label.

⑥ finally the column bar that was previously set to no Fill color is selected, and is dark blue.

⑦ complete, column target progress chart, blue indicates sales quantity, the outer blue border indicates sales target.