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
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL