Data VIsualization

[Ratan Bhushan]

Hi Team
I am uploading performance data of my team.
I am showing how the data playing role in showing it.
But I am unable to decide how should I showing in charts or any other way but taking least space.
Please help

 

[Ratan Bhushan]

Please also advise, if we can create or use heat map

 

[srinidhi]

@ Ratan Bhushan,

Can you explain what do you want to show in the chart or heat map, the target column is blank for most of the columns.
In 7OCR you mentioned If goes up - Green. What should go up, the total or a number in any coulmn. what is the criteria.

 

[Ratan Bhushan]

@ Ratan Bhushan,

Can you explain what do you want to show in the chart or heat map, the target column is blank for most of the columns.
In 7OCR you mentioned If goes up - Green. What should go up, the total or a number in any coulmn. what is the criteria.

@srinidhi

Hi Sri

The value will be entered in the related cell on the weekly basis. The targets are given in the new file which I have uploaded, I want that rather than chart, the cell shows itself where value going. I read somewhere that the heatmap shows the data colorfull accordingly in the cell itself. So I want that if it is possible. Please to check.
I am uploading the new file.

Thanks
Ratan Bhushan

 

[srinidhi]

Hi, Just check if this is what you are looking for.

 

[Khalid NGO]

Hi Ratan,
I think you are looking for:
Conditional format > Color Scales

Regards,

 

[srinidhi]

Hi Ratan,
I think you are looking for:
Conditional format > Color Scales

Regards,

Even I guessed so, Khalid.

 

[Khalid NGO]

Even I guessed so, Khalid.

Srinidhi,
Actually i didn't noticed you already replied

Here is my crank