 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / September 2006Adding Targets on PivotChart
How to add targets on a PivotChart 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 a PivotChart 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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ > You can't add data to a pivot chart that isn't part of the pivot table. > And totals and subtotals don't count. [quoted text clipped - 15 lines] > >> How to add targets on a PivotChart |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.