ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Customizing a Pivot Chart (https://www.excelbanter.com/charts-charting-excel/72330-customizing-pivot-chart.html)

JWalker

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?

Debra Dalgleish

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