Get a chart to update data with varible X-axis

**nikolajfh** · 06-12-2013, 04:13 AM

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

**arlu1201** · 06-19-2013, 02:20 AM

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

**nikolajfh** · 06-20-2013, 02:04 AM

It is solved yes. But in a more creative way. I made a Lookup, sortet the results from largest to smallest, and make my chart from the top 5.
And then the easiest macro I've done so far

Solution.xlsm