I am trying to create a graph using the last 5 business days. If I run this on a Thursday it will pull 3/6 through 3/12. 3/7 and 3/8 were weekends so I don't want them to show up in the chart but Excel automatically throws them in there. The raw data is based off of:
3/6
3/9
3/10
3/11
3/12
But when I put that into a chart, Excel throws in 3/7 and 3/8 with no values. Does anyone know how to get rid of this?
Thanks!!
3/6
3/9
3/10
3/11
3/12
But when I put that into a chart, Excel throws in 3/7 and 3/8 with no values. Does anyone know how to get rid of this?
Thanks!!