Hi,
Did the solution I provided here, not work for you?
http://www.excelforum.com/excel-char...nd-column.html
Cheers
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
Bookmarks