+ Reply to Thread
Results 1 to 4 of 4

Chart data outlines disappearing?

  1. #1
    Registered User
    Join Date
    09-26-2005
    Posts
    34

    Chart data outlines disappearing?

    Hi everyone. This has bugged me for a while but I never thought to ask until now.

    When you have a graph referencing some data close to it, when you click on the chart/graph it will outline the data it's referencing in blue, the series names in green, and the X axis names in purple (for a bar/line graph). This is a very useful function and I end up using it quite a bit.

    The problem I'm running into is that sometimes after creating a chart, I will click on it and and it will outline everything in the data that I stated above. Then 5 minutes later I will click on the same chart and it won't outline any of the data and I can't figure out what has triggered this change. Does this happen to anyone else? Is this a bug or am I doing something wrong? Look forward to hearing from everyone.

    (Sorry to post this in two forums, I didn't see that there was a forum specifically for graphs)

  2. #2
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    If you click on a Data Label the colured lines do not show up, but if you click in the chart area or on a column then they do. Is it that do you think?
    oldchippy
    -------------


    Blessed are those who can give without remembering and take without forgetting

    If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.

    Click here >>> Top Excel links for beginners to Experts

    Forum Rules >>>Please don't forget to read these

  3. #3
    Registered User
    Join Date
    09-26-2005
    Posts
    34
    Hi Oldchippy, thank you for your reply. The problem I am having is that when I click on the chart area it doesn't outline anything on the data cells. Clicking the individual data sets will outline them (such as a bar on a bar graph) but clicking on the chart area won't outline any of the data cells.

  4. #4
    Forum Expert oldchippy's Avatar
    Join Date
    02-14-2005
    Location
    Worcester, UK
    MS-Off Ver
    Excel 2007 (Home)
    Posts
    7,097
    When you click on the chart background do you get a border around the whole chart with 8 black square handles, only when I get that the data is highlighted?

+ 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