I'm trying to produce something similar to the Best Companies Heatmap graphs (attached heatmap.jpg) for a customer satisfaction survey I'm putting together for my IT dept. I've also attached a spreadsheet with some sample data.
Any ideas how to go about this in Excel 2007? Thanks
you can use a clustered bar chart and set the overlap to 100%.
You will need to recalculate values in order to handle correct bar sizes and the split neutral score.
Not sure this is a very clear chart though, you do not normally expect to see negative percentages
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks