Forecast Sheets in Excel – Instructions

Forecast Sheets in Excel - Instructions: A picture of a forecast sheet created in Excel.
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.
Read more
No Comments

Format Trendlines in Excel Charts – Instructions

Format Trendlines in Excel Charts - Instructions: A picture of a user formatting a trendline in an Excel chart using the “Trendline Options” section of the “Format Trendline” task pane.
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
Read more
No Comments

The Field List in Report Charts in Project – Tutorial

The Field List in Report Charts in Project - Tutorial: A picture of a selected report chart in Project 2013 showing the Field List pane.
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
Read more
No Comments

How to Create a PivotTable or PivotChart in Microsoft Excel 2013

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
Read more
No Comments

Formatting Charts in Crystal Reports 2013

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.
Read more
No Comments