I am new to Excel and easily lost in Visual Basic. Here is what I am trying to accomplish:
1. I have four variables: X axis: Value (scale 1 to 5), Y Axis: Risk (scale 1o 5), Complexity: Circle (small, medium and large indicating level of complexity, and Schedule: Green (on-track), Yellow (less than 10% behind Schedule), Red (more than 10% behind Schedule)
2. I have fourteen projects I will need to track; each will be assigned a two to four letter identifier (example: Local Academy Agreements - LAA) which will overlay on top of the circle
3. I want to insert a hyperlink which links the project letter identifier to another project status document (format not identified just yet, however, mostly likely a .pptx or .docx document
I need assistance in first, creating the bubble chart based on the variables noted above. Second, how to insert hyperlinks after the chart is created. Thanks!
1. I have four variables: X axis: Value (scale 1 to 5), Y Axis: Risk (scale 1o 5), Complexity: Circle (small, medium and large indicating level of complexity, and Schedule: Green (on-track), Yellow (less than 10% behind Schedule), Red (more than 10% behind Schedule)
2. I have fourteen projects I will need to track; each will be assigned a two to four letter identifier (example: Local Academy Agreements - LAA) which will overlay on top of the circle
3. I want to insert a hyperlink which links the project letter identifier to another project status document (format not identified just yet, however, mostly likely a .pptx or .docx document
I need assistance in first, creating the bubble chart based on the variables noted above. Second, how to insert hyperlinks after the chart is created. Thanks!
