strange results with xlStackedBar

[SoftwareTester]

While changing from xlBar into xlStackedBar the chart changes very strange.
If I change back all is OK again.

Task Start Finish
Task 1 13-Oct-09 17-Nov-09
Task 2 10-Nov-09 10-Mar-10
Task 3 01-Oct-09 01-Oct-09

I select all 3 columns and create a Bar chart from the menu. All OK
(for each task 2 bars appear, 'finish' being longer)

If I now change the charttype into StackedBar
the (each !) 'Start' bar will occupy the same size like the (each !)
'Finish' bar and will be visibible right in front of (or 'covering half of
the ) 'Finish' bar.

Any idea why it happens and how I can correct it

 

[Jim Aksel]

HI - Try reposting to the Excel newsgroup. This newsgroup is for Project

 

[SoftwareTester]

ehhhh, I agree it's an Excel question. But as I'm working on getting data
from MS Project into Excel nicely I automatically posted it here