Pivot charts are not nearly as useful as regular charts, despite their
pivot behavior. I almost always make a regular chart from pivot tables.
Here's how:

Select a blank cell away from the pivot table.
Start the chart wizard.
In step 1, select the chart type you want.
In step 2, select the Series tab, then use Add to create all the series
you will need. If you use the Data Range tab, the chart will
automatically revert to a pivot chart, and you'll have to start again.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Wowbagger wrote:

I have created a bar graph from a pivot table that shows the number of
events that occurred on specific dates, grouped by month. When I right
click the series to add a trendline the 'Add Trendline' option is grayed
out. Why is this?

Excel 2003.

The original data is in the form of a single column of data, each row
contains only a single date. All dates are valid and there are no nulls in
the data set.