Search results

Hey Narayank, I've got it :). I've given the listbox a name and added the name instead of the index number (i couldnt find it), which works just fine :) Thanks for your help! cheers, Wouter

Hello, I've chosen to work with the code Narayank optioned, and I've assigned the macro to the Listbox where I can choose the KPI's. Bu, whenever I click on the KPI I want, the macro seems to change my choice into the first KPI that is in the listbox (in my example file: whenever I choose...

Thanks for all the replies :) I'll check on monday if these solutions will help me. cheers, Wouter

Hello, At my work, we use excel 2007. I tried to make a little KPI dashboard with a List box (in which the users can choose several KPI's). One of the KPi's is shown as a percentage. Of course, I tried to make some conditional format that changes the number from a normal number to a...

Hello Rahul, You could try this: Add in D2 the formula: =MONTH(B2) and drag down. Then in F2: =SUMIFS($C$2:$C$34;$D$2:$D$34;$G$2;$A$2:$A$34;$H$2) Where G2 is the month (number!) you want to select and H2 is the name of the employee. Cheers, Wouter

Thanks for your replies! The second solution from Narayank seems to work. I've extended the second table with one row and the graph is working properly now! Thanks again :) Wouter PS. How can I change the Title of the thread? I want to add [solved] to it. Or is it a mod thing?

Hi SirJB7, Thanks for your reply. The data range is initialy defined as: ='Charts tryout.xlsx'!TOpermonth but once you select May, this changes to : =Sheet1!$B$16:$F$16 And I'm not sure why I should name the dat in rows 4:9 aswell? cheers, Wouter

Hi there, Today I tried to make a dynamic chart using named ranges. In the file in the link I've made a very basic P&L statement with a chart. The point is to select a certain month and the graph will show you the several lines per month. Everythings seemed to work fine, untill I noticed...

Hi all, I just discovered this awesome site and try to learn as much as possible from it... My name is Wouter, and I live in Rotterdam, the Netherlands. I work as a controller for a (large) multinational. Currently, I'm developing a dashboard, and that's how I got here. See you around at...