Introduction to computer science dessalegn Mequanint Yehuala Foreword

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.

---

---