Removing weekends on column chart

AhhNickk

New Member
Joined
May 15, 2018
Messages
2
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!
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
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
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,552
Messages
6,114,278
Members
448,559
Latest member
MrPJ_Harper

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top