Graph Creation - Maturity Assessment.

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,

Did the solution I provided here, not work for you?
http://www.excelforum.com/excel-char...nd-column.html

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Sasuke" wrote in message
...
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




"Andy Pope" wrote:

Hi,

Did the solution I provided here, not work for you?
http://www.excelforum.com/excel-char...nd-column.html

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Sasuke" wrote in message
...
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,

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Sasuke" wrote in message
...
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" wrote:

Hi,

Did the solution I provided here, not work for you?
http://www.excelforum.com/excel-char...nd-column.html

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Sasuke" wrote in message
...
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

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

Or an XY chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Andy Pope" wrote in message
...
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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Sasuke" wrote in message
...
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" wrote:

Hi,

Did the solution I provided here, not work for you?
http://www.excelforum.com/excel-char...nd-column.html

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Sasuke" wrote in message
...
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