+ Reply to Thread
Results 1 to 3 of 3

Excel 2016 simple line chart issues (label is detached & format won't take for 1 location)

  1. #1
    Registered User
    Join Date
    02-21-2016
    Location
    tampa, florida
    MS-Off Ver
    excel 2016
    Posts
    10

    Excel 2016 simple line chart issues (label is detached & format won't take for 1 location)

    Hello -
    This is my first post, so if I'm starting off wrong, let me know and I'll correct things.
    I have the 2016 version of excel, purchased as a stand alone from MS (but not a part of Office). And I have been merrily learning how to set up a health tracking chart. And I am pleased with it, except there are two issues that I can't seem to resolve, either in trying to noodle them out, or googling them.

    The first is that one of my line labels is not attached to the chart, while all the others are. If I move the chart, everything moves with it, except this one label (Systolic). In experimenting around while learning, I must have done something different with this label to make it detached from the chart, but I can't figure out what.

    The second problem is that, for some reason if i enter an exercise duration on line 15 (F15), the dot shows up, but not the text. All the other boxes work just fine. Again, I must have done something wrong, but can't see what.

    Could someone take a look at my spreadsheet and see how the heck I goofed things up ?
    Attached Files Attached Files
    Last edited by pratto; 02-21-2016 at 01:10 AM.

  2. #2
    Registered User
    Join Date
    02-21-2016
    Location
    tampa, florida
    MS-Off Ver
    excel 2016
    Posts
    10

    Re: Excel 2016 simple line chart issues (label is detached & format won't take for 1 locat

    Well I figured out the second problem - somehow the box containing the text had gotten distorted, and I was able to tell it to resize to fit the text, and to reset the box.

    But the first problem remains, a floating line label.

  3. #3
    Registered User
    Join Date
    02-21-2016
    Location
    tampa, florida
    MS-Off Ver
    excel 2016
    Posts
    10

    Re: Excel 2016 simple line chart issues (label is detached & format won't take for 1 locat

    Got it figured out. I deleted the textbox, and then re-created it, making sure to have picked inside the chart first.
    Now when the chart moves, so does the text box.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Overlaping bar chart percentage data label location help
    By rs1aj in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-14-2014, 09:55 AM
  2. VBA to fix overlap of data label in line chart
    By Faridwahidi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-31-2014, 08:49 AM
  3. Replies: 6
    Last Post: 11-26-2012, 05:17 AM
  4. Adding a second line of results as a label to a pie chart
    By tbaines in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-14-2012, 03:58 AM
  5. Line chart issues
    By Jordec66 in forum Excel General
    Replies: 1
    Last Post: 06-29-2011, 04:15 AM
  6. Excel Chart Y Axis Label Format Problem
    By Jessica.Bush in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-13-2009, 08:14 AM
  7. Label an average line in a dynamic chart
    By John Cordes in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-17-2005, 05:05 AM

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