Graph Creation - Maturity Assessment.

  • Thread starter Thread starter Sasuke
  • Start date Start date
S

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
 
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
 
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
 
Back
Top