Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can I add other data to a pivot chart
I want to add a target line to a pivot chart. The data for the target line
would be from a different source (worksheet) to the underlying pivot table. Is this possible (by workaround or otherwise)? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can I add other data to a pivot chart
A pivot chart can only display data from the pivot table. This can be
overcome by drawing a line and hoping it doesn't move too much. I would instead make a regular chart from the pivot table, and add the data for the additional line. To make a regular chart from a pivot table, select a blank cell that's not touching the pivot table and start the chart wizard. In step 2, you must use the Series tab, and enter the ranges for each series separately. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Sam Wardill" wrote in message ... I want to add a target line to a pivot chart. The data for the target line would be from a different source (worksheet) to the underlying pivot table. Is this possible (by workaround or otherwise)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to apply conditional formating to a pivot chart? | Charts and Charting in Excel | |||
Can I use data from different worksheets to create a chart | Charts and Charting in Excel | |||
Pivot Chart Data Label Format Question | Excel Discussion (Misc queries) | |||
Can I display the actual data in the data field of a pivot chart? | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions |