How to show comparison in a stacked column chart

**michaelsmith2017** · 03-22-2019, 03:02 AM

Hi

I want to show a comparison of two series(series-1 and series-2) in a "stacked column chart". Each series has "min,max and average" values which need to be compared with other series(values of series-1 need to be compared with series-2). Drawing a stacked column chart for any one of these series is pretty simple but i don't know how to display values of both series on the same chart. Sample data file is attached here.
Any help in this regard is highly appreciated.
Regards

**dflak** · 03-22-2019, 11:46 AM

I think this is merely how you arrange the data in the chart. On sheet 2 I use columns A & B as the X-axis and this separates them into two groups.

**michaelsmith2017** · 03-24-2019, 06:23 AM

Hi
Thank you for taking time to reply. What i exactly need to do is to compare values of Series-1 with Series-2 in the following way:
I need to compare value at Series-1 1(Series 1 point 1) with the one at Series-2 1(Series 2 point 1), Series-1 2(Series 1 point 2) with Series-2 2(Series 2 point 2) and so on. So i need a point by point comparison. Can you please guide how to do it?

Best Regards

**JeteMc** · 03-25-2019, 07:45 PM

Hello michaelsmith2017 and Welcome to Excel Forum.
If I understand correctly, perhaps the following will help.
A third range (C27:E36) is populated using: =C3-C15
A stacked column chart is produced based on the new range.
If this isn't what you are looking for, please manually produce (perhaps using paint) and upload a chart that compares the Min, Average and Max of series 1 point 1 and series 2 point 1 in the way you want. We may then be able to replicate the chart and expand it to include the other nine points.
Let us know if you have any questions.

**MrShorty** · 03-25-2019, 08:21 PM

My thought would be to use a clustered and stacked column chart -- which is a basic stacked column chart with extra care in arranging the data in the spreadsheet. Follow tutorial here: https://peltiertech.com/clustered-st...mn-bar-charts/ and let us know which parts you have trouble with.