Bar heatmap Chart in excel

[SajedeZare]

Hi,
I hope all is well with you.
I'd like to make a bar heatmap chart that has 7 bars and each bar consists of 17 parts in the heatmap.
Is it possible to make such a chart in excel?

Thanks

 

[Dan_W]

Heat maps are possible and bar charts are possible, but I'm having difficulty visualizing what the end produxt would look like. Would it be possible at all to post a sample visual of how you would like it to look?

 

[SajedeZare]

Sure. I'd like to have something like this. But with 7 bars and 17 part in each bar.

Heat maps are possible and bar charts are possible, but I'm having difficulty visualizing what the end produxt would look like. Would it be possible at all to post a sample visual of how you would like it to look?

 

[Dan_W]

You could make it with a 2d horizontal stacked bar chart

As an example. The colouring might be tricky though.