Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear QV Experts,
We have few charts in the sheet & need to be exported to XLS SpreadSheet without Macros.
Can you please share your thoughts.
Thanks,
SasikumarR
Hi,
if you want to export the charts data into a single sheet then the only way you can achieve it is to use macro.
On the other way there is the possibility to export a chart one by one in a diff. .xls, but as I understood it is not what are you looking for.
Cheers,
Patric
If each sheet can be exported seperately you can right click on the chart and select Send to Excel or Export, which will then send to a .csv file
Hi Sasi,
in addition to the possibility thatPatric has mentioned, there is a third-party tool called "ReportToMail" which supports exporting charts to Excel - to a specific worksheet and into a specific range of cells. But well, that would again be an additional tool that you'd need.
Without anything extra, I guess Patric's solution is the only one.
HTH
hope this helps you..