Forum Discussion
Witsend_Solutions
Feb 03, 2024Copper Contributor
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...
m_tarler
Feb 03, 2024Bronze Contributor
Witsend_Solutions 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:
- Witsend_SolutionsFeb 14, 2024Copper Contributorm_tarler
This works nicely.. I'll work out how to have the spider web as a 5 point as a default. I notice if you select a 4, then there are 4 points only, but when you select 5 a extra point is added.
For the life of me, I can not see how you created the drop down values in column B and hide them. Unhide is not showing the values. - Witsend_SolutionsFeb 14, 2024Copper Contributor
- Witsend_SolutionsFeb 14, 2024Copper Contributor
m_tarler
Disregard my silly question about the drop downs.. of course its "data", "data validation" rookie error for a seasoned excel bod.- m_tarlerFeb 14, 2024Bronze Contributornp, just glad it is working for you
- Witsend_SolutionsFeb 05, 2024Copper Contributor
m_tarler
Thank you for your response. Determined to find a way...