Hi guys.

Im all new to this forum, and I have a problem I just cant see my way out of.

I want to have a Chart in excel 2010 Copy of WORKFLOW kpi.xlsx that is able to automaticly update the x-axis if there isn't any data.


In the example, I want a macro that chooses last weeks data and only shows the columns with data.
So that the chart in the example for week 23, not shows "costcenter" 1015,1034,1073 etc.


I hope somebody have an idea of what I need, and hopefully will be able to help me!

Kind regards
Nikolaj