Monthly vs Weekly Bar Charts

[Sam_S007]

I have a simple bar chart for monthly frequency data that looks great. I have a separate bar chart for weekly frequency data that looks terrible because the bars are too thin. Why is the width of the bars different for monthly and weekly bar charts?  How do I edit the weekly bar chart so that the bars are the same width as the default monthly chart?

I've attached a copy of the spreadsheet. 

[#2 · Accepted solution]

@Sam_S007 

First cosmetic, I'd change X-axis base on days with 7-days units

As for the bars, format series and select wider border

That will be like

[#3]

Thanks Sergei,

This is exactly what I was looking for!

[#4]

@Sam_S007 , you are welcome, glad to help