Excel formatting while exporting chart data to excel

[vijetas42]

Hi All,

Can I format excel sheet which is exported from any of the chart.please convey your suggestions for the same.

Thanks

[ali_hijazi]

you can export what you see in QlikView

format your pivot table for example and all formatting will be taken to excel (background colors, font colors,etc...)

[vijetas42]

Hi,

if I have a pie chart which is having option send to excel which gives me export like,below image, if I want to change the header color can I do so,

please convey your suggestions on the same.

Thanks!

[vijetas42]

I want export of charts like Pie,Line and Bar charts.in form of formatted excel.

[Bill_Britt]

Hi,

This is not possible. The exports are in BIFF format.

Bill

[vijetas42]

Hi Bill,

Thanks for your reply. Is there any way to achieve this.

Thanks!

[Bill_Britt]

HI,

Not that I know of.

Bill

[Anonymous]

You can use a macro to export data to excel and to format it there.  But macro like this requires system access and can't work on Access Point.