I need to create a chart to display data from an Excel report. The report is drawing the data from SQL using vba in the back ground.
Can you point me in the direction of some sample vba code to create a chart control in Excel?
Also, can anyone comment on the benefits of displaying the chart in either Excel or as a Web Page??