Removing weekends on column chart

[AhhNickk]

Hi all,

New here and noobie to Excel. I'm in the process of creating a PNL chart for personal uses but came up to a problem that Excel kept showing weekend dates on my chart. I've searched around and people say to change the X-Axis type to "Text" but that don't help much because the cells I'm using for the chart is linked to a date else where and that has 3 other pages linked to that date as well. I was wondering if anyone know if I can use a VBA code to hide the weekends on the chart?

Thanks!

 

[mole999]

if you could add a day =text(cell date,""ddd"), in a column, use that as part of the data set and hide sat / sun

 

[AhhNickk]

if you could add a day =text(cell date,""ddd"), in a column, use that as part of the data set and hide sat / sun

Tried, the graph came out all sorts of messed up, it seems like everything got stacked into one bar and everything got send to the left side of the graph.