Tooltip with Category and Values in area chart

[Anonymous]

Hi all,

I have a stacked area chart, which has

• Month as Axis,
• Sales as Values,
• SKU as Category.

What I want is to see Category name and Sales for each hovered area (Month & Category). These are default things shown by Google Sheets diagram:
Is there any way to do this? I managed to create tooltip that works fine on matrix but shows summarized Sales and first Category for each month on chart.
Any help will be appreciated.

[ajayemmadi1]

Hi Omisovets,

As per my understanding, You don't required to use tooltip for your analysis. Just design the chart and do mouse hover on the chart. You can see the labels for each month of mouse hover. 

Regards,

Ajay Emmadi

[Anonymous]

Thanks for the answer, but the thing is that i have 60 different Categories and they all show in one tooltip regardless of where my mouse is. Default tooltip shows only about 10 Categories and it's hard to figure out which Category corresponds to each color.