Treemap. A treemap chart displays hierarchically structured data. The data appears as rectangles that contain other rectangles. A set of rectangles on the save level in the hierarchy equal a column or an expression. Individual rectangles on the same level equal a category in a column. For example, a rectangle that represents a state may contain other rectangles that represent cities in that state. Word 2016 brings with it some new chart types to help you better illustrate data that you include in your worksheets. 
Insert Scatter (X,Y) or Bubble Chart. Preview data as a 2-D scatter or bubble chart. You can preview data as a 2-D or 3-D pie or 2-D doughnut chart. You can preview your data as a 2-D combo clustered column and line chart – or clustered column and stacked area chart.
These charts are best when you have mixed data or want to emphasize different types of information. Chart types include Histogram, Pareto, and Box and Whisker charts. Use these charts to show a statistical analysis of your data. Insert Line or Area Chart. This lets you preview data as a 2-D or 3-D line or area chart.
#Create an xy graph in word for mac 2016 series
The waterfall chart is used to show how a starting value is affected by a series of positive and negative values, while the stock chart is used to show the trend of a stock's value over time. Use this chart to compare a part to a whole or to show the hierarchy of several columns or categories. Insert Column or Bar Chart. This is the first button, located in the top left corner. With this, you can preview data as a 2-D or 3-D vertical column chart or as a 2-D or 3-D horizontal bar chart. You can use these buttons and their dropdown menus to create these types and styles of charts. We're going to go from left to right, starting at the top left, and cover all the buttons above. This should create a graph with min/max lines on it as shown below.To the right of the Recommended Charts button on the ribbon, you'll see this:.
Then select Marker Options followed by None. First right click one of the new data points and select Format Data Series.
The new data points on the graph should then be formatted to make the markers "disappear". Trendlines can then be added for each of the new series of data to create the min/max lines. This will result in 4 new points (2 for each new data set) appearing on the graph, on the error bars of the highest and lowest x values. Repeat the process to add the Max/Min Line 2 data. Click Add and input the Max/Min Line 1 x and y values, then click OK. First select the original graph and then click Select Data under the Design tab. The two new tables of data can then be plotted on the graph as second and third series of data. To achieve this, some additional data must first be generated: Max/Min lines are created using trendlines to connect the lower limit of the first data point (i.e y value minus the error) to the upper limit of the last data point and vice versa. The data (and plot generated from it) for the example used to illustrate this procedure are given below. In some ways a preferred alternative to using regression to find errors in the gradient and intercept is to add max/min lines to a graph, since this determines the error in the gradient and intercept based on the measurement errors made during the data collection rather than just relying on the statistical distribution of the data.Īlthough there is no tool to create max/min lines in Excel, it is still possible to add them by plotting additional data based using the graph error bars/values. PChem Teaching Lab | Excel 10 Using Excel 2010 - Add Max/Min Lines to a Graph
0 kommentar(er)
