chartsmicrosoft excel
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.
When I hover over the areas, it shows only 'series' and 'point'.
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?
There most likely is a limit to the amount of data series in an Excel chart, but I doubt it is as low as 5. Your lines are possibly overlapping.
As you can see here, there is no issue with 6 separate data series in a line chart:
However, if values overlap, only 5 lines are visible:
What range is specified for the X axis in the data source dialog?
If the data looks like numbers, and there is a label in the top left cell of the source data table, Excel will treat the first column like a data series, and not as X axis labels. Make sure that the top left cell (above the labels) is empty before creating the chart.
To fix an existing chart, open the Select Data dialog and adjust the source of the X axis labels.
Best Answer
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.