Excel 2013 In analysis of data that changes both vertical and horizontal axes, ＂＂ ＂＂ ＂＂ ＂＂ ＂＂ ＂＂ ＂＂ ＂＂ ＂＂ ＂
A graph to visualize the two fluctuations is a spray figure.This time, let's check the features of the spray map and the basics that are useful when graphing.
■ Graph of two fluctuating figures
The "spray figure" is effective in graphing data in which both vertical and horizontal axes fluctuates value.By visualizing the place where the value is plotted, it is easy to grasp the tendency, and the data can be analyzed in more detail by using an approximation curve.Another feature of the spray diagram is that multiple objects can be used together to convert them to data and the position in the whole can be grasped.The tendency can be understood depending on where the value is displayed, and it is perfect for analyzing data.This time, I will introduce techniques that are useful for grasping and analyzing data as well as basic creation methods.
■ Use of spray diagrams
↑ Even if multiple are displayed, an approximate curve can be used.Each value is easier to recognize.
■ Make it easier to grasp the scattered values on the whole side
When creating a graph, how to create a base table is very different from other graphs.Further, in a spray map that is easy to scatter, it is easier to grasp the tendency by using an approximation curve.If multiple data is graphed together, changing the marker makes it easier to understand the position of the value.
STEP1 Create a scattered diagram in 2 steps in the recommended graph
↑ A table for creating a spray diagram.The feature is that you can handle two variables.
↑ “Select“ All Graphs ”in the“ Inserted “Recommended Graph” in the “Insert Tab”.
↑ If you select “Sprinkle drawing” from the displayed menu, the graph is completed.Both the vertical axis and the horizontal axis can see the tendency of the data by variable.
Step2 Understand the tendency of data using an approximation curve
↑ Select “Add Graph Element” on the “Design” tab of “Graph Tool”.Select a type by the "approximation curve" of the menu.
↑ “Linear” is ideal when the values of the vertical and horizontal axis are increasing or decreasing at a certain ratio.It is displayed on a straight line.
↑ “Index” is used for data that increases the other increase rate when one value increases.It cannot be used in the case of 0 or negative values.
↑ “Average change” smoothes data fluctuations and clarifies the numerical pattern and tendency.By default, the average of two sections is calculated.
Step03 Clarify the overall position by collecting multiple multiple
↑ When multiple objects are made into a spray diagram, the vertical and horizontal axis numbers are set as a set for each target.It is a more complicated structure than a normal table.
↑ “Create a graph using a recommended graph”.Since the color of the point changes for each target, each tendency can be recognized.
↑ Select “Data series format setting” in the right -click menu of the graph.
↑ Change the type of marker with the “marker option” in the format setting.
↑ Set another marker for each target.The shape changes in addition to the color, and the distribution state is more recognized, such as a place where the value is dense.
■ It is easy to see with the adjustment of the boundary value and the approximate curve
It is assumed that both the vertical axis and the horizontal axis fluctuate, but it is possible to make one pattern based on one as a reference value.If the graph is displayed by biased, adjust the boundary value to eliminate the bias.In addition, when compiling a large number of data, the recognition of the value is easier to use an approximation curve.
↑ Change the value of the “boundary value” with the “axis option” in the format setting.
↑ The minimum value of the horizontal axis starts from “300”.Eliminates the bias of the graph.
↑ If there are many targets, it is easy to grasp by displaying an approximation curve.A similar curve can be combined with different types.
As mentioned above, we have delivered the ＂how to make a spray diagram in Excel.Please use it for practice."Excel Dojo -Secret Society Extension" is being popularly serialized in the Weekly ASCII magazine.Please check it out and enjoy Midori's great struggle!
