Plotting two data series with the same x-axis on the same graph, PLEASE HELP!!

**mnolaniv** · 07-30-2015, 11:43 AM

Hi everyone,
This is my first post but I can't seem to find an answer to my question anywhere on the internet.

I am trying to create a graph with two distinct treatment groups. They were taken over the same 6 sampling dates (so they share the same x-axis labels). However, I want the second treatment group to appear on a completely separate y-axis with a new x-axis on the bottom, but stacked on top of the first treatment group. This way I can compare the two treatments over time. Also, each of the two treatments groups are split into three different levels.

I can get all six data series on one common x-axis and I made all three data series from the second treatment a secondary axis, but I can't figure out how to but those three on top of the first three.

I know that it sounds confusing, I can hand-draw the graph I want to create on paper if that would help. I also have the excel data file if that would help.

This is part of my PhD thesis and it not being able to do this is driving me crazy

**Richard Buttrey** · 07-30-2015, 11:46 AM

Hi,

Yes, the actual data workbook would be useful plus a sketch of the resultant chart you expect. It may be as simple as changing the chart type to a stacked series.

**mnolaniv** · 07-30-2015, 11:58 AM

Ok attached is a ruff hand drawing of what I want and an excel with the appropriate data. Thanks so much for any help!

**mnolaniv** · 07-30-2015, 11:59 AM

I have no idea why the picture is upside down. Sorry about that.

**Jacc** · 07-30-2015, 01:58 PM

Make two separate charts, make the background transparent, no edge line around. Then just scale and stack them together, lock them with the Group function for shapes.