Drawing on a Excel chart using the API
Has anyone managed to draw lines or rectangles on a Excel chart using API
I want to draw a "zoom" box on a chart. I have code to do this working on
a regular VB form, but Excel charts don't have a Device context which is
require for the API calls. I also tried embedding the chart in a Picturebox
and using it's Device context but that also doesn't work.
As a last resort I tried placing a picture box over the chart and then making
it transparent, but the code does nothing once the Picturebox is made transparent.
Anyone got any ideas or sucessfully done this.
BTW I'm using Excel 2000 but would prefer to get this working in Excel97