MLB Pitching Stats Dashboard in Excel+VBA on Chandoo's website

[Heinz]

I recently came to this website of Chandoo (really great!) and arrived also at Dan's amazing dashboard on “MLB Pitching Stats Dashboard in Excel+VBA” done by Dan (excel file can be downloaded here : http://img.chandoo.org/vba/mlb-pitching-stats-excel-dashboard.xlsm ).Really impressive work and I got much inspired for a dashboard that I started to create. Especially the part with the sorting & changing the different KPIs of Dan's dashboard is perfect and I'd tried to use it also for my dashboard. Unfortunately it does not work although I only changed names of the sheet, table and table content, adapted accordingly the VBA code. This does not give any error message but it neither sorts nor changes in between the different items when clicking to the different buttons. Everything works but in the pivot table nothing happens regarding sorting and/or changing the KPI. Hence my question: any idea what I missed to update and is there any short guideline available how especially this part has been done? This help would be very appreciated. Thanks in advance, Heinz

 

[NARAYANK991]

Hi Heinz ,

Surely you realize that the reason why something does not work in your file , has to do with the changes which have been made in your file.

These can be changes to the formulae , named ranges or code.

By uploading an Excel workbook , which contains nothing but an image , you are not doing your cause any good.

The surest way to get a quick answer would be to upload your workbook. Of course , you can always wait for a Good Samaritan.

Narayan

 

[Heinz]

Hi Heinz ,

Surely you realize that the reason why something does not work in your file , has to do with the changes which have been made in your file.

These can be changes to the formulae , named ranges or code.

By uploading an Excel workbook , which contains nothing but an image , you are not doing your cause any good.

The surest way to get a quick answer would be to upload your workbook. Of course , you can always wait for a Good Samaritan.

Narayan

Dear Narayan,
Thanks for your advice and reply. I uploaded a file with faked and very limited data due to sensitivity to simplify any possible help for me; you will see that the upper dashboard that "I" build is very equal to what Dan did in his dashboard (hope that this is fine for him); my problem is the second part (with the button to chose Ascending/Descending order which should change the charts below and also depending on the Indicator I chose; both is certainly linked and does not work like in the example of Dan's dashboard. Thanks for any further support. Kind regards, Heinz