If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Graph Creation - Maturity Assessment.
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 |
#3
|
|||
|
|||
Graph Creation - Maturity Assessment.
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 |
#4
|
|||
|
|||
Graph Creation - Maturity Assessment.
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 |
#5
|
|||
|
|||
Graph Creation - Maturity Assessment.
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 |
Thread Tools | |
Display Modes | |
|
|