Do you find that the charts you make are quite different from those of others? Because you are using the default chart that comes with Excel, and if you want to make the chart more exquisite, we need to make some adjustments.
For example, when making charts, you can’t achieve the desired effect and can’t help being crazy! Especially if the value difference is too large, it may become a mountain-low-valley type or an overwhelming type.
Solving the large differences in charts can enable charts to provide more valuable data presentation.
First Step
1. Beautify the default Excel chart elements: first you need to highlight the title area. Delete the default title, and replace it with a text box.
2. Break through Excel default elements: use all elements. For example, use cells, text boxes, lines, shapes and other self-selected graphics.
3. Color: The color value is determined by the color. Use the PPT color picker, or use the color pick plug-in Coolpix to help modify the color of the chart.
4. Layout: The column chart we often use generally uses vertical composition. You can directly drag the overall size of the chart.
Second Step
1. Eliminate excessive differences
Sometimes we encounter such a problem when making icons: In the same data series, a certain value is too small, which leads to a too large gap in the data, and the resulting chart is very unsightly.
If you use the coordinate axis format, you can easily make the gap between the graphs smaller.
Double-click the ordinate of the chart to open the window for setting the axis format. Check the logarithmic scale and set the reference scale value to 10. The differentiation of the chart will be eliminated.
2. Make the data visible
In the same chart, two data series are compared. The data with a smaller value is almost invisible in the chart, and there is no comparability between the data.
Click OK and you can see a clear comparison chart of the two data.
3. Truncate the maximum data
Comparing the data in the same chart, the performance of other data is mediocre, and there is a certain data but it is optimistic. If this happens to be your competitor, then the work report will be slightly awkward. By truncating the maximum value of the chart, you can alleviate the embarrassment.
First, change the bar data with the largest data to the appropriate data to get a chart with similar differences.
Then click Insert in the menu bar to insert a parallelogram and two straight lines to get a truncated figure. Then click Draw Shape-Format-Combination in the menu bar to make this graphic into a combination. Transform this graph and place it on the highest histogram.
Click the ordinate to delete it. Then click the plus sign in the upper right corner of the histogram to select the actual label.
Finally, just change the modified data back.
4. Add style to the chart
The histograms that we usually make are all rectangular, but if your chart is a shape with a personality, is it more eye-catching than others’ charts?
After making the histogram, click Insert. Draw a shape you like, and then set relevant parameters for its fill and stroke. Select it and use the shortcut key “Ctrl +C” to copy it. Then click on the chart. You can select all the bars and replace them with this shape, or you can select only one or a few and replace with this shape.
It should be noted that if you want to change the style and color of the chart, you need to determine it before changing the shape, and you can edit it individually. Otherwise, everything will be restored.
Third Step
In the production of excel, we often encounter chart operations, so there are more ordinary static charts, and the production of dynamic charts can achieve better performance. So, follow me here to learn about dynamic chart production.
1. Open the table that needs to be made into a dynamic graph. Then copy Monday to Sunday into one column.
2. Click the Developer option in the menu bar, and then select the Insert—Combo Box.
3. Right-click the Combo Box and select Format Control. Then click the first input box, and at the same time select the Monday to Sunday from the copy just now, and fill in their positions. Click the second input box, and then click cell A7 of the table. Check 3-D shading and click OK.
4. Then copy all the product columns under A8.
5. Here comes an important step. Enter “=index (B2:H2, A$7)” in B8, press Enter, and place the mouse in the lower right corner until a black cross symbol appears, drag down to fill. This step is to link the setting of the control just now with the content of the table, so that when the control selects different dates, the chart will change accordingly.
6. Select A8-B11. Click Insert—Charts.
7. Our dynamic chart is completed. Click on the Combo Box and select a date at will. You can find that the chart changes with the date.
8. It can be found that when the space is Monday, the number 1 appears in cell A7, when the date is Tuesday, the number 2 appears in cell A7, and so on. It is precisely because of this change that the change of the control leads to the change of the chart.
In addition, if there is no developer option in your menu bar, you can call it out in the excel option. Click File in the menu bar, then select an option. Click the custom control. Check the developer option in the main control on the right.
