Thread: Graphing Question - Use of multiple graphs (Line and Column)

Hi Guys

Am trying to put a graph together which maps the following:

Y AXIS: (5 categories)
- Funding
- Business
- Management
- Awareness
- Strategy

X AXIS: (6 categories)
- Non existent
- Repeat
- Intuitive
- Managed
- Defined
- Optimised

I am not sure how I can structure the table to input values, or which graph(s) to use to create the output required or whether it can even be done!

Constraints around this include:
- A category on the Y axis can only be assigned ONE category on the X Axis. For example, Funding cannot be Managed and Defined, it can only be one.


I have in mind how I would like it to look, please see attachment provided.

Thanks in advance

You need a combination chart.
Line and Bar in order to have category labels on both axes.



Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Sasuke also posted the question via the MS newsgroups.

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

If you add rows to the table you will need to add Series to the Chart.

Right click chart
Source Data
Add

Then change the added series to Line charts as I think they will default to bars.
Format the lines to have no line and circle markers.