+ Reply to Thread
Results 1 to 3 of 3

Line Chart Showing What I Think Is Progress

  1. #1
    Forum Contributor
    Join Date
    12-02-2014
    Location
    England
    MS-Off Ver
    2010 | 2016
    Posts
    167

    Line Chart Showing What I Think Is Progress

    Hi,

    I have a line chart which I didn't produce but am I trying to understand.

    Please see the attached file to see the chart.

    My query is, why is the first part of the line blue? I'm hoping its showing progress driven by a date but not sure how that works.

    If it isn't showing progress, then how would I make it so it did?

    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Line Chart Showing What I Think Is Progress

    Your chart has 2 series.

    The solid blue line refers to 'Tactical - PB to WG'!$CV$49:$CV$113
    The dashed green line refers to 'Tactical - PB to WG'!$CX$49:$CX$113

    As this worksheet has been deleted from your attachment, it's impossible for us to check the source data, but it looks like there is only partial 'Baseline' data, hence only a partial blue line.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Forum Contributor
    Join Date
    12-02-2014
    Location
    England
    MS-Off Ver
    2010 | 2016
    Posts
    167

    Re: Line Chart Showing What I Think Is Progress

    Ah, was wondering if the different series had any effect and it seems that the ranges are different sizes, leading to different plot length.

    Thanks!

+ 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. Showing combined bar and line chart
    By Lemons83 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-05-2014, 04:47 AM
  2. Gantt Chart showing progress based on data entered.
    By adil.master in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-29-2014, 09:28 AM
  3. [SOLVED] Bar chart showing plus line to indicate another dataset
    By Chrismdlz in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 02-06-2014, 10:07 AM
  4. Radar Chart that is filled in showing quarter progress
    By slinskey in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-06-2013, 09:47 AM
  5. [SOLVED] Chart showing one line for several rows
    By PEA in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-30-2005, 03: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