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? |
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 |
All times are GMT +1. The time now is 01:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com