Hello
In my workbook I retrieve data from an external file.
On the sheet "Controlepaneel" I have a drop down list with sales reps that triggers a series of macros to get the filtered data for the chosen sales rep.
After a series of macros I get a chart on the "Grafiek" sheet showing the sales results for the past months.
Everything works fine for Chris, Els and Yves, but for "René" the chart doesn't show.
As you will notice, the number of rows is different for each of the sales reps, the number of columns is the same (it will only grow with the months to come).
I checked the different macros to get to the chart and all work OK.
I also tried to copy a good working macro and change the data concerning René, but I still don't get a chart.
I checked the empty graph and there are no source data selected.
For the other reps I have the following source data:
CC: =Grafiek!$A$1:$E$98
EV: =Grafiek!$A$1:$E$162
YG: =Grafiek!$A$1:$E$121
When I check for RH, the source data are =Grafiek!$A$1:$E$252. After entering this manually, I get a graph, but rows and columns are reversed compared to the graphs of the other reps.
Switching rows and columns is not possible because Excel limits the number of data rows to 255 (that's what a message box is telling me when I try to do this).
Anyone any idea why the data source is not there?
Bookmarks