ChartPearlsOysters

Bread and ButterWhite Elephants

DepartmentRisk ValueFinancial ValueCostProject NameFinance0.11220125Profit and LossFinance0.45300150Inward ClearingFinance0.89850150Balance SheetInformation Technology0.8195150Public facing WebInformation Technology0.9350150Asset ManagementInformation Technology0.37700170Intranet WebProduction0.2290150Quality ControlProduction0.4400180Maintenance SchedulesProduction0.6210190Shift ManagementPurchase0.25240190Vendor ManagementPurchase0.7700180Invoice ManagementPurchase0.865100Inventory Management

CalculationsDepartmentsPurchaseFinanceInformation TechnologyProductionFind Department in list39303336Find number of rows3333Risk RangeChart!$B$39:$B$41Chart!$B$30:$B$32Chart!$B$33:$B$35Chart!$B$36:$B$38Project Cost RangeChart!$D$39:$D$41Chart!$D$30:$D$32Chart!$D$33:$D$35Chart!$D$36:$D$38Financial Value RangeChart!$C$39:$C$41Chart!$C$30:$C$32Chart!$C$33:$C$35Chart!$C$36:$C$38Instructions1. Add the program name in row one2. Copy row 2 to 6 from previous Column under the new program name3. Create 3 names in the formulas tab -> names section using indirect function. Refer to existing names to create new ones4. Add a new series from the graph -> select data menu and add the newly created names to appropriate series X, Y, Bubble size parameters.

Raw DataDepartmentRisk ValueFinancial ValueCostProject NamePurchase0.865100Inventory ManagementPurchase0.7700180Invoice ManagementPurchase0.25240190Vendor ManagementFinance0.45300150Inward ClearingFinance0.89850150Balance SheetFinance0.11220125Profit and LossInformation Technology0.37700170Intranet WebInformation Technology0.8195150Public facing WebInformation Technology0.9350150Asset ManagementProduction0.4400180Maintenance SchedulesProduction0.6210190Shift ManagementProduction0.2290150Quality Control