I am wondering if anyone can please provide some tips for creating charts for display on screen in a visual basic application.
At the moment I can write values to an Excel spreadsheet where the rows are set to create a chart and that is pasted into the VB appplication. However the number of rows or columns is fixed. At the very least I would like to make the charts dynamic i.e. I might graph two rows one time and seven the other, but I don't know how to dynamically select the values in Excel and then draw the chart in the application.
This would be great if I knew this, but I'd be grateful for any other tips that help me accomplish this task.
Thanks,
Stuart
At the moment I can write values to an Excel spreadsheet where the rows are set to create a chart and that is pasted into the VB appplication. However the number of rows or columns is fixed. At the very least I would like to make the charts dynamic i.e. I might graph two rows one time and seven the other, but I don't know how to dynamically select the values in Excel and then draw the chart in the application.
This would be great if I knew this, but I'd be grateful for any other tips that help me accomplish this task.
Thanks,
Stuart
