Home
Analytics
overlap values issue in export to excel
rajkishore
I was trying to avoid overlap values in export to excel but I couldn't able to do. There are 6 to 7 values with big variance let say 1000000, 1,2,3,11,12,13 are ploted in pie chart while those chart exporting to excel getting issues. could anyone suggest any work around or quick solution. <br><br>
I am using ihub3 , html5 charts and default xls emitter. <br><br>
Note: if I use those values in excel it draws nicely without any issue. <br><br>
regards<br>
kishore G
Find more posts tagged with
Comments
mwilliams
Can you provide an example? If I make a chart with those values in Excel, the labels overlap.
rajkishore
<p>williams,</p>
<p> </p>
<p>Attached is the sample and xlsx as ds.</p>
<p> </p>
<p>when you run this report the value "30" is drawn in nicely in webviewer. when export to excel the value is overlapped.</p>
<p> </p>
<p>if you see the xlsx which is attached in this post. i used same values and drawn pie chart inside excel with out any ovelap.</p>
<p> </p>
<p>i am looking for two solution:</p>
<p> </p>
<p>1. If you could resolve this will be the best option.</p>
<p>2. Export as image option. to do this i need to select the export xlsx page settings "Chart as image". if we modify this option in plugins it will impact all the reports.Instead of selecting the every time could you write explicit script only for this report "Chart as image" selected as by default.</p>
<p> </p>
<p>Thanks for support.</p>
<p> </p>
<p>Regards</p>
<p>Kishore G</p>
<p> </p>
mwilliams
You'll likely need to get a support case filed for all of your issues with the Excel Live Chart outputs. Anything with those will require changes to the emitter (support will need to log this and work with engineering) or for you to create your own custom emitter or try a third party emitter.
rajkishore
<p>thanks williams, a major issue. what ever we did client script it is not exporting either HTML5 or excel issue not sure.</p>
<p> </p>
<p>Are you guys collecting this kind of issue and notifying to the actuate to add it feature version? </p>
<p> </p>
<p>However, case is already raised. </p>
mwilliams
When you open a support case, they'll file an internal bug report with Engineering. If you've done that, you've done all you can probably do for the commercial excel emitter.<br><br>You could always try a different emitter that exports images instead of Live Excel charts to see if that will get you along til the label issue is fixed.