Microsoft Office Tutorials and References
In Depth Information
Creating a Line Chart
Creating a Line Chart
Line charts are typically used when the data consists of values drawn from categories that
follow a sequential order at evenly spaced intervals, as with historical data in which the
data values are recorded periodically such as monthly, quarterly, or yearly.
Ajita wants the summary report to include a chart of the performance history of the
New Century Fund against two other investments: a large growth fund and the S&P 500.
(The Standard and Poor’s 500 is an index of 500 blue chip stocks that is commonly used
to measure the performance of stocks and funds.)
Ajita has already entered this data in the Fund History worksheet. She calculated the
quarterly value over the past 10 years of a $10,000 investment in each of the three funds.
Because there are 40 data points across the three data series, a column chart of this data
would be diffi cult to read and interpret. Instead, you’ll create a line chart for the New
Century Fund performance, plotting the value of the three investments against time.
To create the fund history line chart:
1. If you took a break at the end of the previous session, make sure that the New
Century Fund workbook is open.
2. Go to the Fund History worksheet, and then select the range A4:D44 . This range
contains the data for the value of the New Century Fund, the average value
of large growth funds, and the value of the S&P 500 for each quarter of 2004
through 2013.
3. Click the Insert tab on the Ribbon.
4. In the Charts group, click the Line button, and then click the Line chart (the
first chart in the 2-D Line section). A line chart is embedded in the Fund History
5. In the Location group on the Chart Tools Design tab, click the Move Chart
button. The Move Chart dialog box opens.
6. Click the Object in arrow, and then click Summary Report .
7. Click the OK button. The line chart moves to the Summary Report worksheet.
8. Move and resize the chart to cover the range D1:I9 . See Figure 4-20.
Figure 4-20
Line chart moved and resized
line char t with
three data series
Search JabSto ::

Custom Search