Dashboard creation

[IronMan1982]

HELPPPPPPPPPPPPP...

I have just joined a new team at work and we dont have an MI team yet. no one in my team can do anything excel related other than opening up a sheet and thats about it.

i really need some help creating a risk dashboard that shows the top 10 individuals in certain areas, over all sales figures monthly, and ytd, and i also need to create a heatmap with postcode regions (not indvidual postcodes just the first 2 letters)


i am hoping someone can help me as i dont really know what to do and the deadline is set for friday (they only told my last night!)

any help would be really appreciated...i cannot upload the work spreadsheet as its huge but if anyone can give me any help i will appreciate it. thanks in advance

 

[IronMan1982]

HELPPPPPPPPPPPPP...

I have just joined a new team at work and we dont have an MI team yet. no one in my team can do anything excel related other than opening up a sheet and thats about it.

i really need some help creating a risk dashboard that shows the top 10 individuals in certain areas, over all sales figures monthly, and ytd, and i also need to create a heatmap with postcode regions (not indvidual postcodes just the first 2 letters)


i am hoping someone can help me as i dont really know what to do and the deadline is set for friday (they only told my last night!)

any help would be really appreciated...i cannot upload the work spreadsheet as its huge but if anyone can give me any help i will appreciate it. thanks in advance

i forgot to mention that the info i want on the dashboard i have created via pivot tables.