Charting Primer II

Charting Primer II - ExcelChartingPrimerII ChartTrendLines

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
   Excel Charting Primer II ...dynamic ...dynamic ...dynamic ...dynamic Chart Trend Lines Add a Moving Average Line Add Error Bars to a Data Series A Custom Error Bar Example Stock Chart Add Series Lines ExpandingChart ScrollBarChart StartAndNumber CheckBox Formatting Notes Many of the examples in this workbook were adapted  from the text named  Excel Charts , by John  Walkenbach, Wiley,  2003.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
3 Ways to Chart Missing Data Trend Lines Add a trend line to certain chart types* to get a better idea of how data is trending over time. Excel's  trend line is a best fit line for the charted data series. A chart with a trend line need not have a time or data category axis, but the trend line assumes that the category axis values occur in equal intervals. To add a trend line, that displays. The "Options" tab in this dialog offers forward and backward forecasting. * Line, column, bar, area, XY, stock, bubble.    Il ustr. 2.    Il ustr. 3.    Il ustr. 1. A line chart with trend line and custom trend line name added.     How to add a trend line.    The "Type" tab of the "Add Trendline" dialog.     The "Options" tab of the "Add Trendline" dialog. The Data: Krispy Kreme Volume Date Volume 5/23/2003 460,600 5/22/2003 399,700 5/21/2003 674,300 5/20/2003 896,800 5/19/2003 502,300 5/16/2003 648,700 5/15/2003 635,900 5/14/2003 784,100 5/13/2003 856,300 5/12/2003 820,900 5/9/2003 1,142,000 5/8/2003 784,200 5/7/2003 1,073,400 5/6/2003 703,500 5/5/2003 446,800 5/2/2003 761,200 5/1/2003 978,000 4/30/2003 367,300 4/29/2003 580,000 4/28/2003 370,900    Il ustr. 4. The same chart as above but with a 20 day forward forecast.        Il ustr. 5 4/25/2003 329,900                  The regression equation for the trend line is displayed on the chart.        The "Options" tab selections for this chart. 4/24/2003 699,800 4/23/2003 1,646,400 4/22/2003 473,600 4/21/2003 376,800 4/17/2003 666,500 4/16/2003 400,500 4/15/2003 357,000 4/14/2003 436,200 4/11/2003 504,400 4/10/2003 1,155,900 4/9/2003 566,100 4/8/2003 345,200 4/7/2003 477,800 4/4/2003 462,200 4/3/2003 528,100 4/2/2003 481,700 4/1/2003 537,500 3/31/2003 392,600 3/28/2003 317,800 3/27/2003 635,900 3/26/2003 586,100 3/25/2003 514,600 3/24/2003 888,200 3/21/2003 1,479,600 3/20/2003 1,348,500 3/19/2003 1,274,200 3/18/2003 3,043,000 3/17/2003 933,800 3/14/2003 662,300 3/13/2003 647,200 3/12/2003 408,100 3/11/2003 388,900 3/10/2003 670,200 3/7/2003 727,500 3/6/2003 751,700 3/5/2003 542,300 3/4/2003 377,500 3/3/2003 395,500 2/28/2003 448,500 2/27/2003 348,900 2/26/2003 392,100 2/25/2003 788,400 2/24/2003 716,400 select the chart and from Excel's menus choose  Chart, Add Trendline . Complete the "Add Trendline" dialog Return to Contents 5 / 2 3 / 2 0 0 3 5 / 2 2 / 2 0 0 3 5 / 2 1 / 2 0 0 3 5 / 2 0 / 2 0 0 3 5 / 1 9 / 2 0 0 3 5 / 1 6 / 2 0 0 3 5 / 1 5 / 2 0 0 3 5 / 1 4 / 2 0 0 3 5 / 1 3 / 2 0 0 3 5 / 1 2 / 2 0 0 3 5 / 9 / 2 0 0 3 5 / 8 / 2 0 0 3 5 / 7 / 2 0 0 3 5 / 6 / 2 0 0 3 5 / 5 / 2 0 0 3 5 / 2 / 2 0 0 3 5 / 1 / 2 0 0 3 4 / 3 0 / 2 0 0 3 4 / 2 9 / 2 0 0 3 4 / 2 8 / 2 0 0 3 4 / 2 5 / 2 0 0 3 4 / 2 4 / 2 0 0 3 4 / 2 3 / 2 0 0 3 4 / 2 2 / 2 0 0 3 4 / 2 1 / 2 0 0 3 4 / 1 7 / 2 0 0 3 4 / 1 6 / 2 0 0 3 4 / 1 5 / 2 0 0 3 4 / 1 4 / 2 0 0 3 4 / 1 1 / 2 0 0 3 4 / 1 0 / 2 0 0 3 4 / 9 / 2 0 0 3 4 / 8 / 2 0 0 3 4 / 7 / 2 0 0 3 4 / 4 / 2 0 0 3 4 / 3 / 2 0 0 3 4 / 2 / 2 0 0 3 4 / 1 / 2 0 0 3 3 / 3 1 / 2 0 0 3 3 / 2 8 / 2 0 0 3 3 / 2 7 / 2 0 0 3 3 / 2 6 / 2 0 0 3 3 / 2 5 / 2 0 0 3 3 / 2 4 / 2 0 0 3 3 / 2 1 / 2 0 0 3 3 / 2 0 / 2 0 0 3 3 / 1 9 / 2 0 0 3 3 / 1 8 / 2 0 0 3 3 / 1 7 / 2 0 0 3 3 / 1 4 / 2 0 0 3 3 / 1 3 / 2 0 0 3 3 / 1 2 / 2 0 0 3 3 / 1 1 / 2 0 0 3 3 / 1 0 / 2 0 0 3 3 / 7 / 2 0 0 3 3 / 6 / 2 0 0 3 3 / 5 / 2 0 0 3 3 / 4 / 2 0 0 3 3 / 3 / 2 0 0 3 2 / 2 8 / 2 0 0 3 2 / 2 7 / 2 0 0 3 2 / 2 6 / 2 0 0 3 2 / 2 5 / 2 0 0 3 2 / 2 4 / 2 0 0 3 0 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 Volume Linear Regression for Volume Krispy Kreme Volumes with Trend Line 5 / 2 3 / 2 0 0 3 5 / 2 2 / 2 0 0 3
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 12

Charting Primer II - ExcelChartingPrimerII ChartTrendLines

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online