Chart, Date/Text Axis Format Question

Hello Everyone!

I am having an issue with a chart (Line & Column)... The issue is that on the Column Chart with a Date Axis, there are gaps on days without data (Weekends for my data).... So if I change the axis from date to text, I can eliminate the gaps without a problem....

The problem then becomes the Axis Format... I would like to add gridlines corresponding to the 1st day of each month. While this is easy to while the axis is a date, however I have not figured out how to do it when the axis is text....

Is it possible to have a column/bar chart using a date axis without the weekend gaps where data does not exists, or properly format the axis with gridlines on the 1st of each month corresponding to the same spacing as the representative Line Chart?

I have attached an example of my issue.....

Thank you all in advance for your assistance...

JB

Andy...

Thank you so much for your prompt reply!!! I sincerly appreciate your help!!!

Thanks!

jb