Excel 2007 construction progress crosstab chart creation steps and Practice

[Knowledge]

　　1. Hide some images in the chart

To achieve a special chart effect, you need to "hide" some of the charts except to delete the series (sometimes this method cannot achieve the desired effect ), you can also use the following method.

Step 1: select the chart to be hidden from the chart.

Step 2: switch to the chart tools/formats menu tab.

Step 3: click the "shape fill" drop-down button in the "shape style" group and select the "No fill color" option from the drop-down list that appears later.

2. Adjust the chart width

For columns, bars, and other charts, if you think the width of the chart is not suitable, you can adjust it through the following operations.

Step 1: select a chart.

Step 2: Right-click and select the "set data point format" option in the shortcut menu that appears to open the "set data point format" dialog box.

Step 3: In the "series options" tab, use the "view as you get" function to adjust the values under "Classification spacing" to the appropriate values, and click "close" to return.

[Practice]

Below, we practice the specific process of creating the crosstab chart of the construction progress shown in 1.

Figure 1

1. Create a chart

Step 1: Start Excel 2007 and enter the construction progress data in a worksheet, as shown in 2.

Figure 2

Step 2: select the A2: C14 cell area and create a chart with the "bar chart-stacked bar chart" type, as shown in 3.

Figure 3

2. format the chart

Step 1: In the chart, click the "Start Date" series chart, select it, right-click it, and select the "set data point format" option in the shortcut menu that appears later, open the "set data point format" dialog box.

Step 2: Set "fill" and "border color" to "NONE" and click "close" to return.

Step 3: switch to the "chart tools/layout" menu, select the horizontal axis in the chart, and click the "set selected content format" button in the "currently selected content" group, open the "set axis format" dialog box.

Step 4: In the "axis options" column, select the "minimum/fixed" project, and enter "39414" in the box below. Select the "Maximum/fixed" project, enter the value "39640" in the following box, select the "Main scale unit/fixed" item, and enter the value "20" in the following box "; select the "secondary scale unit/fixed" item, and enter the value "5" in the following box ". others adopt the default format. Click Close to return. (Tip:The value "39414" is the Sequence Value of the start date of "construction preparation": "39640" is the sequence value of a date after "completion acceptance .)

Step 5: select the vertical axis to open the "set axis format" dialog box.

Step 6: In the "axis options" column, select the "reverse category" and "Horizontal Axis cross/maximum category" options. Others adopt the default format. After the settings are complete, click "close" to return.

Step 7: Select the "legend" object and press del to delete it.

Step 8: add the title (for example, "construction progress of building ×1") to the chart ").

Step 9: After adjusting the chart size and other elements, a standard construction progress chart is created.

Skill Link]

Set a background for a chart

If you add a background for the above construction progress crosstab chart, it will be better.

Step 1: click in the icon area and select the chart area ".

Step 2: switch to the "icon tools/Formats" menu, and use the "shape fill" button in the "shape style" group, add a proper "texture" or "image" for the "chart area ".

Step 3: click in the drawing area and select the drawing area ".

Step 4: switch to the "icon tools/Formats" menu, and use the "shape fill" button in the "shape style" group, set the "Drawing area" to "no fill color" format.