Dual X - Axis

Hi,

Im trying to create a combo chart where I have daily data and monthly data.

I want to display daily data as a line and monthly data as the columns but when I do so, the monthly data only shows as a tiny bar on the first of the month.

Is there any solutions to this?

Many thanks