Area: An area chart emphasizes the magnitude of change over time.
•
X Y Scatter: An xy (scatter) chart shows the relationships among the numeric
values in several data series, or plots two groups of numbers as one series of xy
coordinates.
•
Stock: This chart type is most often used for stock price data, but can also be
used for scientific data (for example, to indicate temperature changes).
•
Surface: A surface chart is useful when you want to find optimum combinations
between two sets of data. As in a topographic map, colors and patterns indicate
areas that are in the same range of values.
•
Doughnut: Like a pie chart, a doughnut chart shows the relationship of parts to
a whole; however, it can contain more than one data series.
•
Bubble: Data that is arranged in columns on a worksheet so that x values are
listed in the first column and corresponding y values and bubble size values are
listed in adjacent columns, can be plotted in a bubble chart.
•
Radar: A radar chart compares the aggregate values of a number of data series.
Manual for Laboratory Practices 99
Creating Charts
To create charts for the data by below steps.
• Select the data for which you want to create chart.
• Choose
Insert Tab » Select the
chart or click on the Chart group to see
various chart types.
• Select the chart of your choice and click OK to generate the chart.
Figure 21 Creating a Chart
Editing Chart
You can edit the chart at any time after you have created it.
• You can select the different data for chart input with
Right click on chart » Select data Selecting new data will generate the chart as per new data as
shown in the below screenshot.
