Excel Digest

  Excel help for the rest of us

Archive for the 'Charts' Category

07 Oct

How to summarize data using a pivot table

What is a pivot table?
Pivot table is a feature of Excel that takes a long list of data, summarizes it into a shorter list that is more easy to analyze and assimilate.
The best way to explain how to create a pivot table is by using an example.
In the image below you see a list of [...]

28 Sep

How to view multiple worksheets at the same time

To view multiple worksheets at the same time follow these steps:
1. Open your workbook.
2. In the Window menu click New Window.
3. In the Window menu click Arrange and select an option (Tiled, horizontal .. etc). Now you will have two windows showing the same worksheet.
4. Click on any one of the two windows and select [...]

13 Jul

How to update existing chart, Part 3: Chart Options

As I mentioned in part1 and part 2 of this series you can update an existing chart to change some of its properties without having to recreate the chart from scratch. In this post we will see how to update the chart options:

Click on the chart.
On the [...]

09 Jul

How to update an existing chart, Part 2: Data Series

As I mentioned in part 1 of this series you can update an existing chart to change some of its properties without having to recreate the chart from scratch. In this post we will see how to update the data series:
1. Click on the chart.
2. On the top menu Click Chart, then click Source Data.

06 Jul

How to update an existing chart, Part 1: Data Range

If you have an existing chart and you want to change the source data of that chart, by expanding it for example, then instead of recreating the chart you can just update it as follows:
1. Click on the chart.
2. On the top menu Click Chart, then click Source Data.

25 Jun

A primer on chart terminology

If a picture worth a thousand words as the saying goes then a chart could be a good proof of this.
Excel has a chart wizard that provides the user with a variety of chart types and many options to customize those charts. So in this post I will not get into the details of [...]

© 2008 Excel Digest | Entries (RSS) and Comments (RSS)

GPS Reviews and news from GPS Gazettewordpress logo