Outrageous Project Portfolio Bubble Chart Excel

Just like a scatter chart a bubble chart does not use a category axis both horizontal and vertical axes are value axes.

Project portfolio bubble chart excel. This column displays the calculated value score for each individual Project. Choose No Fill and No Line Color and set the font to Calibri 14. This works fine with line and box charts - bu not with bubble charts.

This is important for identifying projects that drive overall greater value to the organization compared to other projects as well as highlight projects that should likely be screened out. Bubble chart in excel is actually a type of scatter plot in scatter plot we have data points on the chart to show the values and comparison whereas in bubble charts we have bubbles replacing those points to show the comparison and similar to the scatter plots bubble charts have data comparison on both horizontal and vertical axes. Creating the Bubble Chart To start off click anywhere in the data and then on the INSERT tab on the Ribbon in the Chart group click the Scatter menu button.

The weight determines the amount of influence that attribute value will have on the Project ranking. A bubble chart is a variation of a scatter chart in which the data points are replaced with bubbles and an additional dimension of the data is represented in the size of the bubbles. Bubble charts are useful for looking at the relationships between projects because they allow you to see 3 dimensions of data at once represented by the X a.

Bubble Chart in Excel Bubble Chart in Excel is categorized as a part of the Scatter or Bubble chart option available in the insert menu tab. All of the spreadsheet logic. The risk-value portfolio bubble chart represents a portfolio view of all projects and puts projects into one of four quadrants based on value and risk.

This project portfolio managment PPM Excel spreadsheet will compare and rank up to 25 projects using up to 20 different attributes. Furthermore I want to specifiy the data range dynamicaly - by dynamic names for example. I think it has something to do with the sh.

Select one of the Bubble chart types from the menu as shown below. This value score is based on weights assigned to each attribute. Each with its own color and legend entry.