If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Customizing a Pivot Chart
I just completed a pivot table and pivot chart for a customer. The customer
requested additional information on the pivot chart sheet. In this case he would like a the grand total sum displayed as a numeric value in a box just off the chart. Is it possible to display a cell value and a label randomly on the pivot chart sheet? What does it take? |
#2
|
|||
|
|||
Customizing a Pivot Chart
You can display the contents of a worksheet cell on the pivot chart:
Select the pivot chart Type an equal sign Select the worksheet cell for which you want to display the value Press the Enter key Move the text box from the centre of the pivot chart to the location you want to display it. JWalker wrote: I just completed a pivot table and pivot chart for a customer. The customer requested additional information on the pivot chart sheet. In this case he would like a the grand total sum displayed as a numeric value in a box just off the chart. Is it possible to display a cell value and a label randomly on the pivot chart sheet? What does it take? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Location of pivot chart | C Tate | Charts and Charting | 1 | December 16th, 2005 05:01 AM |
Pivot Chart - X,Y & Data Series Options | Graham Haslehurst | Charts and Charting | 4 | November 24th, 2005 02:51 PM |
Pivot Chart Field List Not Enabled | quackerbacker | Running & Setting Up Queries | 0 | November 18th, 2005 12:43 AM |
How do I go from "Chart View" to "Pivot Table Form" in a Pivot ta. | Jersey Girl | General Discussion | 1 | March 10th, 2005 04:20 AM |
Selecting Charts in a Macro | Herman Merman | Charts and Charting | 1 | August 18th, 2004 12:25 AM |