Graph Creation - Maturity Assessment.

[Sasuke]

Hi

I am trying to create a graph that has the following:

Y AXIS:
- Funding
- Business
- Perception
- Strategy

X AXIS
- Non existent
- Repeatable
- AdHoc

An example of how i would like it to look is as follows:.


Funding --------------x------------------------------------------------

Business------------------------------x-------------------------------

Perception ----------------------------------------x------------------

Strategy---------------------------------------------------------x----

Non existent Repeatable Adhoc Mature

Sorry that it doesnt look better, but i think that i need to have a bar and
line chart combination, but am not sure how to do this.

Thanks in advance

 

[Andy Pope]

Hi,

Did the solution I provided here, not work for you?
http://www.excelforum.com/excel-cha...n-use-of-multiple-graphs-line-and-column.html

Cheers
Andy

 

[Sasuke]

Hi Andy

Yea it sort of worked....the graph layout is exactly what i want, however
the mapping of the data is incorrect for my purposes. Please see below
information:

There are 6 maturity levels that I am trying to map (maturity levels on the
X Axis) each with a value assigned:
- Non Existent (1)
- Ad-hoc (2)
- Repeatable (3)
- Defined (4)
- Managed (5)
- Optimised (6)

A maturity level is assigned to each category on the Y Axis. Each category
on the Y Axis can only be assigned to ONE maturity level. The maturity
levels are called from another sheet (which i have no problem with) based on
values (1-6). I need the graph to be able to map back the maturity values
called from the other sheet to the table which will ultimately generate the
graph.

Hope that this makes sense?

Thanks
Sasuke

 

[Andy Pope]

Hi,

That's what the data in the range C3:H3 is doing. Plotting a point for each
Maturity level against a category.
So cell C3 has the value 5. The point is placed at the intersection of
Non-Existent and Funding.

If you need to plot multiple points for a category you will need multiple
series.

I have posted an updated file on the forum.

Cheers
Andy

 

[Jon Peltier]

If you need to plot multiple points for a category you will need multiple

series.

Or an XY chart.

- Jon