PPT graphic tutorial for changing line chart and data (pedometer instance)

Step 1:Open powerpoint 2013 and insert a chart:(Similar effects can be achieved in version 10, but some functions are missing. We recommend that you use version 13)

Step 2:Insert a composite chart and modify the chart attributes in the window: line chart, area chart, and scatter chart. Select the secondary axis after the scatter chart ".

Step 3:Modify data. Set the line chart data to 3000 ~ A random number of 10000, using the Excel function randbetween (). The area chart data is set to the same as that of the line chart. Change the category name to the time format.

Step 4:Set the boundary of the primary and secondary axes to 0 ~ 12000.

Step 5:Add an auxiliary sequence, including average, maximum, minimum, today, and average.

In the figure above, how can the values in the blue box change with the data? Here we use the scatter chart data label customization method.

Prepare several groups of data:

The first group is used for the average line scatter chart, and the data is calculated using the average () function. The second group is used for the data label and the value is 11000, so that the position is fixed above the chart.

The third group uses custom data labels, min () for the minimum value, max () for the maximum value, formula = recent value for the current value, and average () for the average value.

Step 6:Click "design-edit data ",

Series NameEnter at will,X axis series valueObtain the first column of a group of scatter chart data,Y axis value generationIn the second column of a single group of scatter chart data, add two groups of scatter charts in sequence.

Add data labels to the second group of scatter charts, select a custom sequence for tag data, and select a value for the third group of auxiliary data. Delete the scatter chart generated when the chart is inserted, and adjust the boundaries of the secondary abscissa.

Step 7:Adjust the format of each element in the chart to complete the chart.

 

 

The above is the guide to "using PPT to create changed data tables". Although The tutorial is only a few simple steps, it involves a lot of things. We suggest you start it over and over again, otherwise it will be hard to learn.