Forum Discussion
Excel 365 Create Spider Web like Diagram but not using data
Hi Team, I am trying to insert an image or create one directly in Excel 365 like the one shown here, but to have the end user be able to click on the "Dots" which then puts a larger circle (just big...
... and then you will find yourself up to your neck in VBA and chart mouse events, with the possibility of needing to place shapes (circles) within the chart. Sorting out pixels, points and grid co-ordinates for various screen settings can also be somewhat exciting. The book Professional Excel Developer has a section on this but unfortunately the book is getting old now and I think the references to libraries are for 32 rather than 64 bit machines.
Chart MouseDown, MouseMove and MouseUp Events in Excel (brainbell.com)
- Thanks Peter.
I shall reference this book and see if it can be done.
