The previously SOLVED thread - http://www.excelforum.com/excel-char...cel-chart.html
doesn't work if I want to also hide the data that would appear on the X-axis. I am using the formula =IF(ISERROR(Q14*3/G14),NA(),(Q14*3/G14)) on a week by week basis, to hide the DIV/0 results in the y axis, but future dates in the x axis are still appearing. EG today I have a chart with data appearing for weeks ending up to 07/03/14, but on the x axis the future weeks ending 14/3/14 and onward are still appearing with blanks on the y axis
Bookmarks