Hello! I am new to the forum, and I am hoping I can become a valid member. I am decent with Excel, I have programming knowledge (engineering student), but for some reason, this chart is not working out the way I wanted it to.

My problem involves trying to make a chart out of two different sets of data.

Each series is a section of data that basically acts as a length, and I was hoping to generate a stacked column with all the series adjact to each other vertically. The stacked chart in Excel works fine for this.

The problem arises when I want to add another column to compare side by side with the first. Excel wants to make the second column relatable to the first column but I want the series to be independ of each other.

Basically 2 independent columns with series that are related, but not related between columns.

Does anyone know the best way to format the data in Excel so I can make this chart properly?


I attached my workbook with the data. Please and thank you some much forum members!

Excel_Forum_blosoya_help.xls