Hello friends, today to share with you a chart making skills.
First, let's look at the following data:
These data are different departments, different months of sales, to use this data to make a chart to show the performance of each department changes, by default, the inserted chart is like this:
It's a mess.
Let's look at the effect of this chart:
Is it that the value of the face has increased by N percentage points?
Of course, you can also set other chart colors according to your preference.
Next, let's talk about the specific production method.
First, click any cell in the data range and insert a line chart with data markers.
2. Select any data series in the chart and set the shape outline color to light yellow.
Click the other data series in turn and press F4 to set all the line outlines to light yellow.
Third, select one of the data series and set the data label to light yellow. Click the other data series in turn, press F4, and the data points are all set to light yellow.
Then click the chart gridline and press delete the Delete key, the same way to delete the legend item.
Fourth, the next definition of the name:
彩色 =OFFSET($B$1:$G$1,$A$9,)
Note that A9 in the formula is a cell with no data.
5. Enter the following formula in cell A13, the role here is to use as the chart title:
= OFFSET ($A $1, $A $9,) & "First Half Year Sales"
Select the chart, add the data series, and add the name you just defined to the chart.
7. Add the finished chart display effect:
8. Simply beautify the newly added data series data point style, and set the fill color for the drawing area and chart area of the chart:
9. Insert a control button:
Next right-click the control and format it:
10. Drag the control to the upper right corner of the chart, hold down the Ctrl key, click the control and the chart in turn, right-click → combination.
11. Select the chart title, enter the equal sign =in the formula bar, and then click cell A13, and then press Enter.
Finally, drag the position of the chart title to set the chart font.
Well, click on the controls and select different departments to take a look at it:
Photo production: Zhu Hongzhong