Chart Wizard In Excel 2011 Series And Data

Chart Wizard In Excel 2011 Series And Data

After you choose the data series and data category for your pivot chart, you indicate what piece of data that you want plotted in your pivot chart.

However, Excel also gives you the option of using the Insert Chart command on an existing pivot table.

After youve done this, Excel assumes you want to work with the entire table.

In Excel 2007 and Excel 2010, to get to the menu with the PivotChart command, you need to click the down-arrow button that appears beneath the PivotTable button.

Excel then displays a menu with two commands: PivotTable and PivotChart.

Its a good idea to store the to-be-analyzed data in an Excel TableRange.

If you do so, click the Select a Table or Range radio button.

If you followed Step 1, Excel should already have filled in the Range text box with the worksheet range that holds the to-be-analyzed data, but you should verify that the worksheet range shown in the TableRange text box is correct.

Note that if youre working with the sample Excel workbook, Excel actually fills in the TableRange box with Database A1:D225 because Excel can tell this worksheet range is a list.

For example, if the range is cell A1 to cell D225, you can type A1:D225.

Now use the mouse or the navigation keys to select the worksheet range that holds the list you want to pivot.

Select either the New Worksheet or Existing Worksheet radio button to select a location for the new pivot table that supplies the data to your pivot chart.

Most often, you want to place the new pivot table onto a new worksheet in the existing workbook the workbook that holds the Excel table that youre analyzing with a pivot chart.

If you do this, you need to select the Existing Worksheet radio button and also make an entry in the Existing Worksheet text box to identify the worksheet range.

Excel inserts a new chart sheet in the workbook that you use for the pivot table and uses that new chart sheet for the pivot table.

Excel displays the new worksheet with the partially constructed pivot chart in it.

You need to decide first what you want to plot in the chart or what data series should show in a chart.

But this is another one of those situations where somebodys taken a ten-cent idea and labeled it with a five-dollar word.

And a chart legend names the data series that a chart shows.

To use coffee products as your data series, for example, drag the Product field to the Legend Field (Series) box.

After you do this, you get the partially constructed, rather empty-looking Excel pivot chart.

Your second step in creating a pivot chart is to select the data category.

That sounds complicated, but in many charts, identifying the data category is easy.

In the case of this example pivot chart, to show how coffee product sales change over time, the data category is time.

Chart Wizard In Excel 2011 For Mac