X Y Scatter and Bar Chart Combined for two sets of data - (similar in look to Stock Graph - Open High Close)

[marenello99]

Hi, sorry if this has been asked before (I did a quick search, but I'm not exactly sure how to phrase it!).

I have some data for a company, lets say Jim's garage, this consists of a number of products, for ease, product 1, product 2 and product 3. I have quartile data for each product (Lower, Median and Upper) and I want to place this on a graph in the style of an XY scatter graph. Along the bottom of the graph would be product 1, product 2 and product 3. Then above each of the product titles would be the LQ, Median and UQ markers.

However the bit I can't do is then to compare it to the quartile data for the same products at the other garages in the chain. I want these shown as a floating bar chart behind the scatter graph reference points. So I can see where Jim's garage has higher and lower UQ, median and UQ figures. Very similar in look to the 'Stock Graph' ' Open High Close' option, but also showing the median figure.

Thanks for any help you might be able to offer!

Regards
Richard

 

[marenello99]

Not sure if this picture might help as it shows what I'd like to end up with
https://drive.google.com/file/d/0B5PZsI-4-k6QejNzaGUtRWt6Ync/view?usp=sharing

this is a picture of the stock graph I was talking about!

Any help would really be appreciated!