and the second one:
But there is something weird about these charts. When you look at select data in the first case you get:
In the second case we see two more columns:
I will explain why this happens.
To make it possible to switch between to chart, I used this dataset, from A1:D11:
Next I created several names, to make it all work:
Here transposing is needed to show the data in the right direction, not from left to right, but from top to bottom. Multiplying by 1 is needed to transform the range in to one series.
In cell G2 you can switch between Apart and Together. In cell H2 the choice will result in 1 or 0. and then hid column H. This will have consequences: When we pick Apart, allSecond and allThird will refer to column H, which is not visible, and disappear from the chart.
After choosing Together in cell G2, I created a graph based on columns A, B, C and D. Then made series refer to respecitively:
The horizontal axis labels I refer to:
You can download the file ExcelApartTogetherII.zip through this link: