Create a Weird Column Chart

Parra

Well-known Member
Joined
Feb 21, 2002
Messages
752
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. :eek:

Thanks

Parra
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

mjbeam

Well-known Member
Joined
Apr 6, 2002
Messages
756
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

Well-known Member
Joined
Feb 21, 2002
Messages
752
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

Well-known Member
Joined
Apr 6, 2002
Messages
756
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
 

Forum statistics

Threads
1,147,621
Messages
5,742,184
Members
423,710
Latest member
Duarte85

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top