Looking for solution in Excel power pivot..

Question

I am working on Microsoft Power Pivot and not able to find a way out for following .

· Hide/Show Chart series by check/uncheck legends.

 · Display Tooltip and its formatting while one hover the mouse on to any report section.

Please help... Its very urgent

Answer 1

Take a look here:

http://www.brighthub.com/office/home/articles/4906.aspx

Answer 2

Actually what i need is the tooltip in the the pivot charts and tables created on powerpivot..

The link above explains the tooltip when one click on the cell but i want to show the tool tip even when someone hovers on the cell or chart..

Answer 3

Hi,

For a PivotTable, right-click it, point to PivotTable Options, and then click Alt Text. There specify a title(optional) and description(must).

For a  pivot chart, selct whole chart are right-click it, click Format object/format chart area, and then click the Alt Text pane.

Once you export it to browser there you can see the description you specified by hovering.

Look at below link for morte details

http://office.microsoft.com/en-us/excel-help/add-alternative-text-to-a-shape-picture-chart-table-smartart-graphic-or-other-object-HA010354748.aspx?CTT=5&origin=HA102013545

-------------------------------------------------------------------------------

Please mark as answer if helpful