Stacking data without stacking everything

[JMCostello]

I have the following situation, a 2003 Excel spreadsheet that is broken down
by like this:

Monday | XXX |YYY | Tuesday | XXX | YYY
1
2
3
4

I want the X Axis to be based on the 1,2,3,4 But I want to stack the data
like this:

|Monday| |Tuesday| |Wednesday|
|XXX1 | | XXX2 | |XXX3 |
|YYY1 | |YYY2 | |YYY3 |
___________________________________
1 2 3

However I cannot figure out how to break it down like that, I end up
stacking all the data stacked up so I have all of it based by 1,2,3 instead
of broken down otherwise. I tried a secondary access but then I can't line
it up right. Any suggestions of clarification would be greatly appreciated

 

[Jon Peltier]

The Monday data has to be in row 1, the Tuesday data in row 2, etc, so that
Monday is plotted on the first category, Tuesday on the second, etc. This
means you have to either insert a lot of blank cells, or put all the XXX
data in one column and the YYY in the next, regardless of day.

- Jon