Create a Weird Column Chart

[Parra]

Here is what I am trying to do:

Imagine 2 columns next to each other but they are both for the same year.
The first column has data from 2 rows and each data is its own color and the 2nd column is from data in the 3rd row.

How could I create such a column chart? Of course this will be for 5 years worth of data.

Why, I don't know why, Management just says Do it.

Thanks

Parra

 

[mjbeam]

Imagine 2 columns next to each other but they are both for the same year.

For some reason this reminded me of the movie Conan the Barbarian:

"Two snakes coming together – facing each other – but they are one…."

Sorry. Anyway...I'm not sure I follow you as to how your data is laid and how you want the chart to look.

Please clarify and I'll see if I can help.


-Mike

 

[Parra]

That was funny.

OK Let see if I can draw it out. I can't download the html editor so I will have to do my best.


OOO
OOO
XXX
XXX
XXXWWW
XXXWWW

2004

So here is the data, both columns are for 2004, however the X & O's are in one column but the W are in another.

Yes, like the snake with two heads.

Any suggestions?

 

[mjbeam]

I'm sorry I'm still not following you. So what happens if you just highlight the data and make a graph? What don't you like about the resultant graph?

-Mike