Linking OLE Excel charts with data in a report
I want to create an x-y scatter chart of a type that cannot be done using the built-in Crystal Reports charting tool (I need to plot more than one series). I'm able to created the chart in Excel and add it to my report using OLE. However, how do I link the Excel chart so it reflects the data in the report. The report data is returned from an Oracle database and will change each time the report is run.
If this is not possible with Excel can you recommend a dedicated charting tool that I can use instead.