complex bar graphs

[mramoxia]

Hi,

I have no idea if you can do this in excel or not. I can't attach the spreadsheet or paste the image I wanted because it is hard to explain but here goes.

I want a bar chart that on the vertical axis say test1, test2, test3. The horizontal axis have 1 to 12. So it will have a bar for test1 from 1 - 3 then 3 - 5.3 and they are colour coded by the rating of 5 and 3 and so on.

Does that make sense? Is it possible?

[TABLE="width: 192"]
<tbody>[TR]
[TD="class: xl63, width: 192, colspan: 3"]test1[/TD]
[/TR]
[TR]
[TD]KM start[/TD]
[TD]KM end[/TD]
[TD]Rating[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]5.3[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]5.3[/TD]
[TD="align: right"]6.4[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]6.4[/TD]
[TD="align: right"]9.8[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]9.8[/TD]
[TD="align: right"]10.5[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]10.5[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63, colspan: 3"]test2[/TD]
[/TR]
[TR]
[TD]KM start[/TD]
[TD]KM end[/TD]
[TD]Rating[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]2.5[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]2.5[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]7.7[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]7.7[/TD]
[TD="align: right"]8.5[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]8.5[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]9[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl63, colspan: 3"]test3[/TD]
[/TR]
[TR]
[TD]KM start[/TD]
[TD]KM end[/TD]
[TD]Rating[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]2.2[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]2.2[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]7.8[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]7.8[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]5[/TD]
[/TR]
</tbody>[/TABLE]

 

[VBA Geek]

Re: graph help - complex bar graphs

Do you mean something like this?

 

[mramoxia]

Re: graph help - complex bar graphs

Hey VBA Geek, close! I would prefer it on a continual bar with no drop downs as there is a lot of data. Is that possible?

 

[VBA Geek]

Re: graph help - complex bar graphs

Hey VBA Geek, close! I would prefer it on a continual bar with no drop downs as there is a lot of data. Is that possible?

Is this closer?

 

[mramoxia]

Re: graph help - complex bar graphs

Yes that's exactly what I'm after thanks VBA geek. How did you manage to do that?

 

[VBA Geek]

Re: graph help - complex bar graphs

You can do it with with Bars or with an XY Scatter. I attach the file with both methods:

Download the file

 

[mramoxia]

Re: graph help - complex bar graphs

Thank you so much for that, great work!