Hover values in chart

[Midas]

I have a line chart with a secondary vertical axis with values
displayed on the right of the chart. When I hover over this secondary
data line I get a message box that gives me the "series", "point" and
"value". The "point" however is a number depending on how far you are
from the left side of the chart. If I hover over the primary data line
the "point" displays the value on the x-axis.

There doesn't seem to be a way to specify the data sequence for the
secondary x-axis. How do I get the secondary data line to show the
"point" value taken from the primary x-axis?

Regards, Midas

 

[Jon Peltier]

I just created a chart similar to yours. Series 1 has a series formula like
this:

=SERIES(Sheet1!$C$4,Sheet1!$B$5:$B$10,Sheet1!$C$5:$C$10,1)

which means

=SERIES(title, x values, y values, plot order)

When I hover, it shows the contents of C4 as the series title, the
appropriate item within B5:B10 as the point label, and the matching item
from C5:C10 as the value.

When I added the second series, I purposely did not identify X values, so
the series formula looks like this:

=SERIES(Sheet1!$D$4,,Sheet1!$D$5:$D$10,2)

There is no entry for x values. When I hover, it shows "point 1", "point 2".
If I copy the x values range from series formula 1 and paste it into series
formula 2:

=SERIES(Sheet1!$D$4,Sheet1!$B$5:$B$10,Sheet1!$D$5:$D$10,2)

the series now has explicit x values, and the appropriate label is displayed
when I hover over a point.

- Jon