Chart is not clearly visible when downloaded the report to excel
HI All,
When Export to Excel The Chart is not clearly visible..
my chart is Dynamic.
less bars it working fine. as practical upto 60 bars working fine. after visibility is low depending number of bars.
my chart bars 200 bars
when export to PDF it is working Fine.
I am Using Sql Server 2008 R2.
Anybody Help.
Thanks
Please Any Body help.
Thanks
April 23rd, 2012 11:06am
Hi Revathi_M,
When we export reports to Excel format, there are limitations on exported reports due to the BIFF's format capabilities. For example, the maximum number of columns in a worksheet is limited to 256.
To work around the issue, I suggest that you add page break to the chart, or add one or more chart controls to the report and filter each chart. For more information, you can refer to Paul Turleys answer in the following thread:
PageBreak in a Bar chart Report
Reference:
Exporting to Microsoft Excel
Regards,
Mike Yin
Free Windows Admin Tool Kit Click here and download it now
April 24th, 2012 10:55pm