+ Reply to Thread
Results 1 to 5 of 5

Line chart to show all values

  1. #1
    Registered User
    Join Date
    12-07-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    39

    Line chart to show all values

    Hi

    I'm trying to create a line chart which shows months at bottom and value up to 100 on the left hand side. I want each risk to appear on the chart but when I try doing this all the risks lines do not appear on the chart. Sorry not sure if I'm making sense but please have a at the attached screen shot.



    July Aug Sept Oct Nov Dec Jan Feb Mar
    Risk 1 100 100 100 50 50 50 25 25 25
    Risk 2 100 100 100 100 100 100 50 50 50
    Risk 3 100 100 100 50 50 50 25 25 25
    Risk 4 100 100 100 50 50 50 25 25 25
    Risk 5 100 100 100 50 50 50 25 25 25
    Risk 6 50 50 50 50 50 50 25 25 25
    Risk 7 50 50 50 50 50 50 25 25 25

    Many thanks
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by sunshine82; 06-10-2015 at 10:07 AM.

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Line chart to show all values

    The reason is that some of the data matches other data so the lines are on top of each other. For instance, Risk 3, 4 and 5 are the same, so it only shows Risk 5, Risk 3 and 4 are on the same exact line because they have the same exact data as Risk 5 so they do not show.
    Last edited by gmr4evr1; 06-10-2015 at 10:31 AM. Reason: Corrected typo
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Registered User
    Join Date
    12-07-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    39

    Re: Line chart to show all values

    ok thanks for that.

    Is there any way I can stop the chart from calculating the values. For example, I need the chart to show values at 100 and not at 200, 300 etc.

    Thanks

  4. #4
    Registered User
    Join Date
    12-07-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    39

    Re: Line chart to show all values

    Anyone know what's the best way to create a line chart with this data please?

  5. #5
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: Line chart to show all values

    If you right click on the chart then click Select Data, you can choose the data you want it to display.

+ 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: 0
    Last Post: 01-29-2014, 08:10 PM
  2. [SOLVED] Chart Lengend to show marker style on hidden line - Line chart
    By etaf in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-22-2013, 05:19 PM
  3. 2010 Line Chart Show Zero Value Line
    By erock24 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-27-2011, 08:54 PM
  4. Show line conditionally - Line Chart
    By idrisb59 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-20-2008, 12:45 PM
  5. Show dot on line chart
    By Bill_S in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-15-2006, 01:08 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