KB429048: Exporting Graphs to Excel lose formatting when exported to in MSTR 10.2 Developer and Web

SUMMARY:
 
When exporting a dual axis graph to Excel, formatting and visuals may be lost during the export process. For example, when a line and bar graph is shown on a Report Services Document, the line is no longer displayed after export as seen below:
 

STEPS TO REPRODUCE:
In Tutorial 10.2

1. Create a new report with cost, revenue, and region
2. Change to graph view
3. Right click on the graph and modify the graph options
4. Within vertical bar options, check the "Dual Axis" option
5. Within "Series" drop down, change one metric series to "Line"
6. Save and close the report
7. Create a new RS document that utilizes the report
8. Add the report to the "Detail Header" section
9. Run the dashboard
10. Export the Dashboard to Excel (On VM 2010 was used)
11. Notice that the line portion is missing
12. Export from web yields same behavior

 
CAUSE:
This issue has been logged as a defect.
WORKAROUND:
Use embed bitmap instead of live chart when exporting to Excel. Edit document, go to Tools > Document properties, change graph format in export setting to “Use embedded bitmaps”
The reference number for this article is 
KB429048