High-low-average chart with 3 lines per process

Hello Guys,

I have a chart which lists the following data:

Process name/Min MAX AVG-T1/Min MAX AVG-T2/Min MAX AVG-T3
Process1 / 1 3 2 / 1 3 2 / 1 3 2
Process2 / 1 3 2 / 1 3 2 / 1 3 2
Process3 / 1 3 2 / 1 3 2 / 1 3 2
Process4 / 1 3 2 / 1 3 2 / 1 3 2
Process5 / 1 3 2 / 1 3 2 / 1 3 2
Process6 / 1 3 2 / 1 3 2 / 1 3 2

I would like to present this as high-low-average lines, but present it the following way:
Process 1, and three lines for T1, T2, T3, then process 2, again with three lines for T1,T2,T3, etc. and each line presenting the min, max and avg values.

Is this possible? Thank you in advance!

P.S.: Thanks Glenn!
I have attached a sample workbook showing the results just for T1. I need T2 and T3 shown next to T1 at Process 1.
Ef_example7.xlsx

Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Maybe like this?

I often find that data layout is important for this sort of thing, which often makes these things more about the spreadsheet than the chart.

One thought -- if you will arrange the data in the spreadsheet in more of a "list" than a "table", then the chart may be much easier to create:

Please Login or Register  to view this content.

From this data layout, you can use A2:B200 as the horizontal category axis data, C2:C200 for the "min" data series, D2:D200 for the "max" data series, and E2:E200 for the "average" data series in the "high-low-average" chart that you currently have. I think that should be pretty close to what you want.

Thank you McShorty! Very nice suggestion! I will try it right away and show the results!

Here is the final result!1z4abkw.jpg

Thank you for your help guys!