I have a combination chart on Excel 2013. It has both lines and stacked areas. When I hover over the lines, it shows all relevant information ('series', 'point' and 'value') of the data point.

Over line

When I hover over the areas, it shows only 'series' and 'point'.

Over area

I've done some research, but this doesn't seem to apply, the File > Options > Advanced > Chart > Show Data Point Values on Hover is checked. Besides, I wouldn't see anything on hover if it weren't.

Any idea how to display the value on hover?

  • @pnuts, no I haven't asked there. – GUI Junkie Mar 4 '15 at 13:15
  • @pnuts, doesn't seem to be any question there. – GUI Junkie Mar 4 '15 at 13:23
  • 1
    This is unfortunately all you get from an area chart. – Jon Peltier Mar 23 '15 at 21:01

Indeed, as Jon Peltier mentioned above, the area chart does not show the y-axis value. I switched to 'Line chart' and 'Area Line chart' (on excel 16.x on OSX) and both showed the corresponding value off the y axis.


Throw that same field twice in your pivot and go to Design / Change Chart Type / Combo. Keep your first field as a line chart and make the chart type for the second field (which is duplicate) "Area". Now, go to your chart and select the line curve and make it invisible.

  • That's an interesting approach. When I have time, I'll check it out. Thanks! – GUI Junkie Mar 8 '19 at 8:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.