Forecast Sheets in Excel: Overview You can insert forecast sheets in Excel into a workbook to predict future trends from existing time-based data. To create forecast sheets in Excel, you must have a series of date or time entries for the timeline. You must also have corresponding values for those time or date entries.
Format Trendlines in Excel Charts: Overview You can easily format trendlines in Excel charts if you applied them to one or more chart series. To format trendlines in Excel, click the “Format” tab within the “Chart Tools” contextual tab in the Ribbon. Then select a trendline to format from the “Chart Elements” drop-down in
The Field List in Report Charts in Project: Overview You can use the Field List in report charts in Project to change the data shown in the chart. The Field List in report charts in Project appears in a pane at the right side of the application window. Here you can modify the fields
Click here to view the complete tutorial Creating Pivot Tables and PivotCharts You can use the PivotTable feature of Excel to access some of the most powerful data-analysis that Excel can provide. PivotTables allow you to organize massive amounts of data in more coherent and meaningful
Editing Charts You can edit a chart object once it has been created, if needed. You can click the chart object once to select it and set the focus of the application to the chart object. It will appear with a blue border around its perimeter so that you can tell when it is selected.