Create a Boston Matrix in Excel.

[taylo40]

Hello,
Can anybody help me please ?

I am in the process of evaluating the projects that the business would like to fo in the next financial year. Each project has been given two scores, one for impact on the business and the other for feasibility.

Idealy, the business would do the high impact, high feasibility projects first. I would like to illustrate the results in a chart.

Does anybody know whether you can do a Boston Matrix in Excel ?

Regards,


Jamie

 

[SkipVought]

Jamie,

Use a Scatter Chart to position points in 4 quadrants.

You can even "color" each quadrant using a hidden secondary axis with a stacked column -- but one thing at a time.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[taylo40]

Skip,
Thanks for the tip but still a bit confused.

Before logging my initial query, I had a go with a scatter chart but it did not give the results I wanted.

Each project will have 2 scores, one for impact and one for feasibility. I thnk that one project should appear one on the chart (impact on the X axis and feasibility on the y axis) however, by using the scatter chart, each project appears twice, ie, one score for impact etc.

Jamie

 

[taylo40]

Skip
Sorted it. The way to do it is for each project to be given its own series in the chart.

Thanks for your help

Jamie