1

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?

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

2 Answers 2

Reset to default
0

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.

Improve this answer
0

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.

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .