Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Export Bex Chart to Excel

Hi All,

In my WAD template, I have created two buttons to enable me to toggle between displaying a 'table' or 'chart'.  I also have a button to Export to Excel.  Exporting to Excel works fine when the table is visible, however when I toggle to display the chart and then click on export to excel, the chart is not being exported, the excel file is blank.

The export button has these commands:

Command = EXPORT

Export format = XLS

Web Item = Default

Show Export Dialogue = On

Are you able to advise as to which settings are required to enable exporting to excel when a chart is being displayed?

I tried changing the Web Item to have two parameters, ANALYSIS and CHART_ITEM_1, however this did not appear to work for me.


Kind regards,

Ross

Former Member
Former Member replied

Hi Karthik,


I have the answer.  Within the Export to Excel button parameters, using Command=EXPORT, I set the Web Template to the same named template as I'm using.  Previously, it was set to a SAP Standard template called 0ANALYSIS_PATTERN_EXPORT, I've changed this to my Z* web template name and now exporting both the table and chart works fine.

The very best to you,

Ross

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question