Adding Targets on PivotChart

[How to Add targets on PivotCharts]

How to add targets on a PivotChart

 

[Jon Peltier]

You can't add data to a pivot chart that isn't part of the pivot table. And
totals and subtotals don't count.

You can make a regular chart from the pivot data. Start with a cell that's
not part of or touching the pivot table, start the chart wizard, then in
step 2, use the Series tab to define the data. (Using the Data Range tab
will change the chart irreversibly into a pivot chart). Then you can add a
series to display the target:

http://peltiertech.com/Excel/Charts/AddLine.html

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


"How to Add targets on PivotCharts" <How to Add targets on
(e-mail address removed)> wrote in message
news:[email protected]...

 

[Jon Peltier]

You might have some success in a pivot chart if you include calculated
fields. Someone emailed me to say it could be done, but there was no
example, and I haven't had time to figure it out from scratch.

- Jon