Jack_Warburton1991
New Member
- Joined
- Sep 16, 2016
- Messages
- 1
Hi, I have recently set up dashboard in excel 2007 and have created a few charts using the offset & match function (formula below).
=OFFSET(Data!$A$8,MATCH(Hire!$A$9,Date_Range,0),12,MATCH(Hire!$E$9,Date_Range,0)+1-MATCH(Hire!$A$9,Date_Range,0))
This looks at some data and the user can use data validation drop down's and select a 'from' date and a 'to' date to display the month's they want to see in the chart.
The problem I have at the moment is that when I select certain month's in the drop down, the chart is showing incorrect month's, unless I choose to show all of the month's and it then works.
Hope this is something somebody out there can help with!
Thanks
Jack
=OFFSET(Data!$A$8,MATCH(Hire!$A$9,Date_Range,0),12,MATCH(Hire!$E$9,Date_Range,0)+1-MATCH(Hire!$A$9,Date_Range,0))
This looks at some data and the user can use data validation drop down's and select a 'from' date and a 'to' date to display the month's they want to see in the chart.
The problem I have at the moment is that when I select certain month's in the drop down, the chart is showing incorrect month's, unless I choose to show all of the month's and it then works.
Hope this is something somebody out there can help with!
Thanks
Jack
