+ Reply to Thread
Results 1 to 3 of 3

Line Chart not displaying all series

  1. #1
    Forum Contributor
    Join Date
    02-26-2015
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    248

    Line Chart not displaying all series

    Hi,
    Hoping someone who is really good with charts can look at my worksheet and give me a couple of examples of what I could do with it with respect to charts. I can do simple ones but when the data increases I get lost. The attached line chart for example only shows two lines but there is clearly 4 in the legend. The point isn't to get someone to do this for me but show me what can be done. Hopefully once I have a better grasp it won't be such a struggle in the future. I've been all over the web and I am just getting nowhere. Clarity would be so much appreciated. Thanks in advance.
    Attached Files Attached Files
    Last edited by BDD2015; 08-11-2017 at 10:32 PM. Reason: Change Title

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,598

    Re: CHARTS - I just don't get them!!!

    title updated, thanks,

    When you selected your data range, you selected only D3:E34 (pph)
    You should have selected the four columns: D3:G34 for your data source range (pph & hrs)
    Attached Files Attached Files
    Last edited by protonLeah; 08-11-2017 at 11:23 PM.
    Ben Van Johnson

  3. #3
    Forum Contributor
    Join Date
    02-26-2015
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    248

    Re: CHARTS - I just don't get them!!!

    Hi, protont.eah
    Thanks. And sorry for the delay in replying. I saw this earlier this am and starting looking at your sample before I replied which led me off... And you are absolutely right! Thanks for pointing it out. I've spent a whole lot of hours on charts since last night and the pieces have started coming together. Thanks for your time.

+ 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. Replies: 32
    Last Post: 07-17-2018, 03:08 AM
  2. [SOLVED] Vary Colors in Pivot Charts based on values (Overlay Charts)
    By TitansGo in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-18-2017, 04:36 PM
  3. [SOLVED] Copy Excel Charts to PPT (Minimum 4 Charts on each PowerPoint Page)
    By E5254730 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-01-2016, 02:36 PM
  4. Replies: 0
    Last Post: 10-12-2015, 03:25 AM
  5. Replies: 2
    Last Post: 09-15-2015, 04:12 AM
  6. copying multiple charts from excel to word overwriting previous charts
    By eric45 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-01-2013, 11:11 AM
  7. Replies: 1
    Last Post: 05-09-2007, 11:35 AM

Tags for this Thread

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