Excel 365 Create Spider Web like Diagram but not using data

Question

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 bigger than the dot) on that point in a defined colour.Multiple points can be selected.As you can see there are 5 circles ranging in size, along with lets say spokes which align to each of the names. If the tasting note of the "Citrus" is the strongest, then the outer most "Dot" nearest to the "Citrus" heading is selected and coloured in "Red"&nbsp;Really appreciate some guidance on this. Thank you in advance.&nbsp;

witsend_solutions · Answer

m_tarler&nbsp;&nbsp;Thank you so much for this.. This will work nicely.

peterbartholomew1 · Answer

Witsend_Solutions&nbsp;Just to report that I have made a little progress in Excel 365 desktop version towards using chart user selections to generate data settings.&nbsp; It takes two clicks to select a point within its series and another to display the change so it is not very slick.The figure is on a chart sheet to simplify the event handling.

witsend_solutions · Answer

Peter,Thank you very much for your effort on this. I like what you have done and very appreciative.

m_tarler · Answer

Witsend_Solutions&nbsp; I don't know of any realistic way to do what you're asking (may be possible writing VBA code to do most of it but IMHO that is beyond the scope of this help forum and probably easier to just program it in another package)HOWEVER, you can create a sheet with inputs for each catagory and DISPLAY your Flavor Wheel:&nbsp;

peterbartholomew1 · Answer

Witsend_Solutions&nbsp;... 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.&nbsp; Sorting out pixels, points and grid co-ordinates for various screen settings can also be somewhat exciting.&nbsp; 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)

Forum Discussion

Excel 365 Create Spider Web like Diagram but not using data

Resources