How to export a chart to Excel correctly?

[former_member1017295]

My Chart ends up in cell A1 with the Excel fixed width but the height correct when I export to an Excel file. How do I format my chart to at least look similar?

Are there some fundamental set up parameters to set?

[former_member30]

Hi and welcome to the SAP Community!

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members.

Should you wish, you can revise your question by selecting Actions, then Edit.

Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.

Cheers,

Julia SAP Community Moderator

[ayman_salem]

Which version are you using (BI 4.xxx SPxxxx Patchxxxx)?

[ayman_salem]

see KBA 2052496 - How to export WebIntelligence reports to MS Excel for optimal formatting

..

Incidentally, since your BI 4.2 SP07-P300 (currently BI 4.2 SP07-P1300 - this is the last patch for SP07), more than 25 problems (through Excel export) have been fixed in these patches.

[former_member1017295]

SAP BusinessObjects BI Platform 4.2 Support Pack 7 Patch 3

Version: 14.2.7.3168