Export pivot table with linear gauge charts to excel

[Anonymous]

Hello,

i'm having a pivot table with linear gauge charts and two open requirements:

1. have the values be shown on top of the graph ( i found out already that this does not seem to be possible)

2. The possibility to extract the pivot table into excel including the graphical represenation (build in function allows only to export the data into excel).

Is #2 somehow possible at all?

Cheers in advance

pijatida

[robert_mika]

You can copy/paste your chart into Excel

Copy To Clipboard-Image or Object or using Macro to do that but this always will be bitmap

[Anonymous]

Yeah.. the bitmap is not helping since it's only part of the table then.. not the part where i would need to scroll down or to the right.

[robert_mika]

Could you expand this thought?

Screenshot maybe.

[#5]

You may have to use NPrinting to achieve this. Do you have NPrinting available?

Regards,

KKR

[Anonymous]

Looks like a Macro is going to do it. currently working on that.

So basically i export a pivot table that shows linear gauge graphs into XL and then run the quick analysis and highlight the cell according to the percentage..

So i have something like this later in Excel....

[MK_QSL]

You have several options, but not a single straight forward option available !

1) Use Macro to export your table...

2) copy image and past to excel

3) NPrinting

[Anonymous]

Yeah.. will probably go with option 1