Excel Gantt chart showing milestone tasks (zero duration)

[civillman]

Hello

I am trying to create a gantt chart in excel with stacked bar chart
It works fine for tasks with duration greater than zero,
but for tasks with zero duration, nothing appears on chart as it is stacked bar diagram
so i try to draw milestone tasks with scatter chart seperately which works fine, but i can not combine these data in one chart
Is there any way to show all tasks in same chart?
i could find many gantt chart examples but all was without milestone tasks

Thanks for your help