Hello,
I'd like to change the x-axis with values from the table to generate a Gantt chart.
I have no problems to create a chart with for example a range from calendar week 20-51.
I have added some rows to help me to scale the axis (J7 and J9 / K7 and K9).
In those cells, I search for the lowest and highest date and change it to a calendar week.
I also changed the numberFormat to "0 KW" KW means calendar week in German.
It is working in a range of one year, but as soon as I switch to another year it plots the graph wrong (the reason is obvious week: 42 - 15 makes no sense with this logic right now).
Is there a way to combine week and year and use this to plot the axis (with VBA, because it should be done automatic every time)?
I added two files, one is working because the range is in between 1-52 and the other isn't working because it switches from 2016-2017-2018.
Additional information:
- Rows A:I are automatically generated (don't touch those please)
- I can add as many "helping" rows as I want.
- Files are in German, VBA in English, if you don't understand something then ask me.
Kind regards,
Niko
Bookmarks