+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : Hovering Mouse over data points on a chart

  1. #1
    Registered User
    Join Date
    12-07-2010
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    3

    Hovering Mouse over data points on a chart

    When hovering the mouse over a data point on a chart in Excel 2007 the data point is not displayed. This scenario only exists for one of the multiple computers Excel 2007 is installed on. I have tried clicking the chart to make it the active item before hovering the mouse over the data point but that was unsuccessful.

    Example
    Name Value1 Value2
    a 1 2
    b 3 4
    c 5 6

    I turn this into a scatter plot. In excel 2007 one should be able to click the chart then hover the mouse pointer over a data point to have excel display ("3" 3,4) etc. One of the computer's I have does not display this information.

    Is there a setting I may have changed on this computer to prevent the display of this information? The problem exists on any graph.
    How should I go about investigating the problem?

  2. #2
    Registered User
    Join Date
    12-07-2010
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Hovering Mouse over data points on a chart

    Hi Spmurphy,

    You need to change this in excel options.

    Press the office button (top left) then select Excel option (button at the bottom right of the drop down menu).
    You then need to select the advanced tab and scroll down the the sub section Display.

    In there you will find "show data point values on hover", you need to ensure this is checked.

    Thanks

  3. #3
    Registered User
    Join Date
    12-07-2010
    Location
    Texas
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Hovering Mouse over data points on a chart

    Solved

    Apparently I did not check every options menu. Thanks for the prompt solution.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1