Jasperverdam
New Member
- Joined
- Jan 21, 2016
- Messages
- 9
Hi all,I'm trying to plot a regular line chart for every week this year with sales numbers, that are being extracted from a different sheet.Normally it plots 52 weeks, but since its week 4 now there are 48 empty points on the horizontal axis.I need these to be removed. So not only to I need to data points to be removed (I am aware of the NA() and customizing the format of the cell) but I need those axis to be removed as well so that it only shows week 1 to 4 and its actually a decent looking chart, and not one where 4 weeks of data are pushed to fit within 1cm and then 48 empty weeks on the x-axis. Next week, it will extract new sales information and it will automatically include week 5 in the line chart when it is week 5(I intend to do this using =today() and =weeknum(today()). Any help is much appreciated.Cheers,Jasper