excel2007 platonic polyline starts from 0

First, organize the data we need into the table as shown.

Next up is the production of Plato.

Step one: Select the data shown in the yellow part, click Insert Column Chart on the menu bar, select the two-dimensional column chart, and generate the column chart shown in the figure below.

Step 2: After the column chart is generated, right-click the column chart and select "Select Data", and the chart will appear block diagram shown.

Click "Add". Fill in "Defect Percentage" for the sequence name, select the yellow undercoated data in the picture below in the sequence value column, and click OK. Select the "Defect Percent" you just added, right-click and select "Change Series Icon Type", and select the line chart in the box chart that appears.

##Generate the graph shown below, click For the red "Defect Percentage" data line, right-click and select "Set Data Series Format" and select "Secondary Axis" to generate the following graph.

After completing the above steps, we will find that the starting point of the line chart is not at the origin. How to adjust Can it start from the origin?

Step 3: Double-click the icon border, click "Layout" - "Coordinate Axis" in the menu bar, and select "Secondary abscissa axis" - "Show left to right axis". Right-click on the coordinate axis that appears and select "Format Icon Area". Set the content of the black border in the image below to the content shown in the image.

After completing the above content, we will find that the graph has basically been formed.

For more Excel-related technical articles, please visit the

Excel Tutorial column to learn!

The above is the detailed content of excel2007 platonic polyline starts from 0. For more information, please follow other related articles on the PHP Chinese website!