I would like to create a bubble chart using MS Excel variables. The visual will tool is meant to help my manage team projects in an IT environment. The spreadsheet and visual will be posted on SharePoint.
attached is a mock-up of the desired outcome and specific criteria for the overal development.
+ “Scope” Size of bubble should reflect of project – not to overlap bubbles
+ “Timeline” axis should be rolling to include all dates
+ “Priority” axis should be low 1.0 to High 10.0
+ “owner” name should be inside bubble
+ “internal or external” should be inside bubble using parentenses (I) or (E)
+ “Task” can be called out inside or outside of the bubble
There should be logical separation of bubbles to accommodate up to 50 bubbles
* Bubble colors should change based on complexity with logical, appealing color gradients. (your choice)
* Over-due tasks should be outlined in Red for visibility
* Bubbles should be visually appealing using modern color schemes (not too loud or too dull)
* This chart should be in standard Excel format
* I will accept ‘some’ variation to my overall plan to accommodate efficient creation of this document. You are the developer; therefore, I will trust your expertise and judgment.
* If you see an opportunity to make it better or I am open to ideas.