Results 1 to 6 of 6

Missing lines on line chart but legend shows all.

Threaded View

  1. #1
    Registered User
    Join Date
    12-29-2010
    Location
    NY
    MS-Off Ver
    Excel 2007
    Posts
    35

    Missing lines on line chart but legend shows all.

    Hi there, I've been battling this one for over a week and am about to lose my mind. Charts are my one major excel kryptonite. They rarely do what I want and I don't understand why. I've even taken a class on it but when I get to real world data it still often goes sideways.

    I wanted to create a chart to show total $ of adjustments by category (reason for adjustment) with months as the X axis. I created a line chart and I can see all three of my categories in the legend, but only one of the lines shows up on the chart itself.

    I've been playing around in chart settings but have had no luck. Can anyone see where exactly I've gone wrong? This particular problem happens to me often. Would love to learn. Thanks so much!

    Hoping my attachment comes through on this post.
    Attached Files Attached Files
    Last edited by poetstorm; 03-20-2024 at 02:20 PM. Reason: Marked solved

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Legend in dynamic line chart name not appearing
    By miisstina in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-23-2014, 09:19 PM
  2. How to create a Line Chart with Legend Filter
    By hemanthjava in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-09-2014, 10:32 PM
  3. Adding Legend next to lines in Line Chart?
    By johanna0507 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-06-2013, 09:53 AM
  4. Legend & Line Chart data overlap - Automatic Fix?
    By jkatsalis in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-24-2013, 05:36 PM
  5. Highlighting corresponding legend and a chart line
    By Cynic in forum Excel General
    Replies: 0
    Last Post: 06-26-2012, 12:07 PM
  6. Legend Only Shows Used Axis on Dynamic Chart (X, Y and Y2 axis)
    By TEBrown in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 06-21-2012, 10:15 AM
  7. Lines missing in line chart
    By Dave_lineless in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-13-2005, 04:05 PM

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