Insert > Chart, select column in the Chart Wizard dialog box, and then click Finish to create a column sheet, as shown in Figure 2.
Figure 2
2. Click the 2nd February data series to select it, and then select Graphics > Graphics type, open the Graphics Type dialog box, select Line Chart, and click OK, as shown in Figure 3.
Figure 3
3.
in Excel, it's a good idea to display the data through a column chart. However, ordinary column charts are always boring or mundane. If you make some interesting style changes to a normal column chart, you make the chart more dynamic.
First, make a cone chart.
Select the correct graphic
The first thing to determine is which type of graphic is better suited to the data you want to represent. For example, a pie chart fits in part with the overall comparison, the bar chart is fit to show the difference between incremental categories, and so on. Like this one, the pie
A method of inserting a column chart in Excel. The specific actions are as follows:
1, in the Excel worksheet interface: First the data grouping type (such as area A1-B8)
2, click Insert-Chart-column chart. And then click the planar histogram in the
Generate the corresponding graphic based on the parameters passed in
Copy Code code as follows:
Loadchart:function (Data,item) {
var that = this;
Require ([' echarts ', ' echarts/chart/bar ', ' echarts/chart/line ',
' Echarts/chart/pie '], function (EC) {
That.body.setHeight (800);
var MyChart = Ec.in
Florence Nightingale Rose chart making method.
PS: This figure from the appearance of the characteristics of a "radius of the pie chart", originated from Florence Nightingale out of the statistics of the results will not be attention to worry, she developed a colorful chart form, so that the data can be more impressiv
The GA report, in addition to the default tabular display of data, also supports pie charts, horizontal percent graphs, PivotChart reports, and so on, where the horizontal percentage chart is the easiest way to visualize traffic, like this:
So what do we do when we want to do something similar in Excel? Especially if the data source is not from GA.
How does Excel color a chart?
1. Color scheme
Data item primary color (RGB)
With rosy, red, red and other colors, used to emphasize the chart, suitable for reading, and ppt projection clear.
Double data series secondary data color matching with the corresponding light, forming complementary color
The background color is mainly light t
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.