Thursday, November 17, 2011

How to Do Trend Charts


Insert Chart
1. Open the saved Excel worksheet.
2. Click the 'Insert' tab on the command ribbon.
3. Click and drag the cells with the categories and numeric data.
4. Click the lower-right arrow for the Charts dialog box launcher. A chart gallery appears.
5. Select a chart type that best communicates your numeric data: 'Area,' 'Bubble,' 'Bar,' 'Column,' 'Line,' 'Stock' or 'xy (scatter). Select an unstacked, 2D chart type.
6. Click 'OK.' The chart type appears over the worksheet.
Add Trendline to Chart
7. Click in the chart area. The Chart Tools ribbon appears with three tabs: Design, Layout and Format.
8. Click the 'Layout' tab.
9. Click the arrow to the right of the Chart Elements text box in the Current Selection group.
10. Click the preferred chart element to appear in the chart area. For example, click 'Legend' to insert a legend box.
11. Click the 'Trendline' button in the Analysis group. A list of options appears.
12. Click the 'More Trendline Options' link. The 'Format Trendline' dialog window opens.
13. Click the 'Trendline Options' button in the left pane. The right pane displays a trendline gallery.
14. Click one radio button in the Trend/Regression Type section: 'Exponential,' 'Linear,' 'Logarithmic,' 'Polynomial,' 'Power' or 'Moving Average.'
15. Select the options for 'Trendline Name,' 'Forecast' and other trendline details. The trendline appears on the chart.

Blogger news