Results 1 to 5 of 5

Line chart to show all values

Threaded View

  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.

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