Chart needs to delete future values and axis

[Jasperverdam]

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

 

[DILIPandey]

Hi Jasperverdam,

You can use dynamic defined names as a range in your chart.
Suggest you to check internet about Excel: Dynamic Defined Names.

Regards,
DILIPandey

 

[Jon Peltier]

Check my tutorials on Dynamic Charts:

Dynamic Charts
Dynamic Chart Review
Easy Dynamic Charts Using Lists or Tables

 

[DILIPandey]

Thanks Jon


Regards,
DILIPandey