I am trying to figure out a way to retain the wrap text formatting that I have in one of my charts when I export to Excel. When I send to Excel the wrap text format is gone.
My expression in the chart is like:
Dim_1 and Dim_2 are two fields in the datamodel and I need to have them in separate lines. I am able to accomplish this in QlikView chart with the Expression and checking the Multiline option in the Presentation tab.
But when I export to Excel the wrap text format is gone.
Is Macro the only way. If yes, can anyone help me with the Macro.