Bar chart Data Problem... Pls help

[Craigmacs]

Does a stacked bar chart need falttened data to work.
For example

If I use

Col1 Col2 Col3 Col4
25 25 25 25

I get a stacked bar chart.
If I have

Col1 25
Col2 25
Col3 25
Col4 25

I get 4 bars. I can't find a way to get the stacking bars to work unless I Flatten the data. I can't faltten all the data for every chart in my report.

My question is:
Is there a way to use the stacked bar chart without Flattening all my data.