I'm in the process of making multiple graphs, and a couple of them are for the 52 weeks of the year, so, at the moment my graphs have that ugly line along the bottom.
I know that this can be removed by creating a formula to display NA so the line does not appear, But the source data is put on automatically with a cell offset macros which is done at the end of the week amongst other things, so If NA was displayed, then the cell offset would not paste into the relevant cells as they are not vacant.
So is there any type of formatting on the charts I can do to not get this line!
Thanks
Bookmarks