none
Export SQL Server report chart to excel as editable chart

    Question

  • Hi,

    When I export the report in excel format the chart is displayed as picture. I want it to be displayed as editable chart.

    Does Office Writer work in this situation and did anyone use Office Writer to accomplish same type of problem.

    Is there any other method or product we can use instead of the office writer.

    Thanks.

    Thursday, July 17, 2014 8:38 PM

Answers

  • Hi Brad_user,

    Just as you said, the chart displays as a static image after exporting to excel, and it cannot be edit. The feature that a chart can be editable after exporting to Excel is not supported in current release of Reporting Services. One workaround for you is create a chart base on the same data in the excel level. Notice that there are many features supported on one side but not the other.

    Alternatively, if you have any concern about this, please submit a feedback at https://connect.microsoft.com/SQLServer/Feedback. Connect site is a connection point between you and Microsoft, and ultimately the larger community. Your feedback enables Microsoft to make software and services the best that they can be, and you can learn about and contribute to exciting projects.
     
    Thank you for your understanding.

    Regards,
    Katherine Xiong


    Katherine Xiong
    TechNet Community Support

    Tuesday, July 22, 2014 3:17 AM
    Moderator