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?

test1
KM start	KM end	Rating
1	3	5
3	5.3	3
5.3	6.4	2
6.4	9.8	3
9.8	10.5	5
10.5	12	1
test2
KM start	KM end	Rating
1	2.5	3
2.5	5	5
5	7.7	4
7.7	8.5	2
8.5	9	1
9	12	4
test3
KM start	KM end	Rating
1	2.2	4
2.2	6	5
6	7.8	3
7.8	12	5

<tbody>
</tbody>

 

[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!