Can Anyone Advise on How to Create a Line Chart

%3CLINGO-SUB%20id%3D%22lingo-sub-2154609%22%20slang%3D%22en-US%22%3ECan%20Anyone%20Advise%20on%20How%20to%20Create%20a%20Line%20Chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2154609%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EObjective.%26nbsp%3B%26nbsp%3B%3C%2FSTRONG%3EI%20am%20trying%20to%20create%20a%20%3CEM%3Eburn%20down%20chart%3C%2FEM%3E%20to%20show%20the%20progress%20of%20software%20development%20projects.%26nbsp%3B%20I%20have%20a%20simple%20deliverables%20matrix%20outlined%20like%20below%3A%3C%2FP%3E%3CP%3EColumn%20A%20-%20Line%20Items%20like%20Project%20Scope%2C%20Team%20Charter%2C%20etc.%3C%2FP%3E%3CP%3EColumn%20B%20-%20Anticipated%20deadlines%20like%20Jan-1%2C%20Jan-5%2C%20Jan-10%2C%20etc.%3C%2FP%3E%3CP%3EColumn%20C%20-%20Completed%20dates%20entered%20when%20a%20line%20item%20is%20completed.%3C%2FP%3E%3CP%3EThe%20legend%20or%20vertical%20axis%20should%20list%20the%20line%20items%20in%20Column%20A.%3C%2FP%3E%3CP%3EThe%20horizontal%20axis%20should%20be%20the%20date%20range%20for%20the%20duration%20of%20the%20project.%3C%2FP%3E%3CP%3EThe%20line%20should%20plot%20to%20Column%20C%20to%20show%20progress.%3C%2FP%3E%3CP%3E%3CSTRONG%3EProblem.%3C%2FSTRONG%3E%26nbsp%3B%20After%26nbsp%3BI%20have%20inserted%20the%20chart%2C%20when%20I%20select%20data%20from%20column%20A%2C%20I%20get%20numbers%20not%20the%20text%20line%20items%20for%20the%20legend.%26nbsp%3B%20When%20selecting%20the%20dates%20I%20get%20a%20single%20date%2C%20or%20numbers%20from%200%20to%201.%3C%2FP%3E%3CP%3E%3CSTRONG%3ERequirements.%3C%2FSTRONG%3E%26nbsp%3B%20As%20I%20update%20progress%20I%20can%20add%20the%20new%20data%20to%20the%20lines%2C%20so%20it%20does%20not%20need%20to%20be%20totally%20automatic.%3C%2FP%3E%3CP%3EThanks%20for%20any%20suggestions%2C%3C%2FP%3E%3CP%3EBrent%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2154609%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2154778%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20Anyone%20Advise%20on%20How%20to%20Create%20a%20Line%20Chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2154778%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F974129%22%20target%3D%22_blank%22%3E%40TecEFX%3C%2FA%3E%26nbsp%3BCould%20you%20upload%20the%20chart%20that%20you%20are%20working%20on%2C%20with%20some%20of%20the%20underlying%20data%3F%20Be%20sure%20to%20remove%20any%20confidential%20information.%20I'm%20asking%20because%20your%20description%20is%20not%20entirely%20clear.%20You%20mention%20that%20there%20are%20three%20columns%3A%20Line-items%2C%20Due%20dates%20and%20Completed%20dates.%20I'm%20wondering%20what%20values%20you%20intend%20to%20plot%20in%20a%20line%20chart.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Objective.  I am trying to create a burn down chart to show the progress of software development projects.  I have a simple deliverables matrix outlined like below:

Column A - Line Items like Project Scope, Team Charter, etc.

Column B - Anticipated deadlines like Jan-1, Jan-5, Jan-10, etc.

Column C - Completed dates entered when a line item is completed.

The legend or vertical axis should list the line items in Column A.

The horizontal axis should be the date range for the duration of the project.

The line should plot to Column C to show progress.

Problem.  After I have inserted the chart, when I select data from column A, I get numbers not the text line items for the legend.  When selecting the dates I get a single date, or numbers from 0 to 1.

Requirements.  As I update progress I can add the new data to the lines, so it does not need to be totally automatic.

Thanks for any suggestions,

Brent

4 Replies

@TecEFX Could you upload the chart that you are working on, with some of the underlying data? Be sure to remove any confidential information. I'm asking because your description is not entirely clear. You mention that there are three columns: Line-items, Due dates and Completed dates. I'm wondering what values you intend to plot in a line chart.

@Riny_van_Eekelen 

Hi Riny van Eekelen,

Thanks for the interest in my chart.

Here is a screen shot

TecEFX_0-1613981735080.png

Dates for project duration on bottom horizontal axis

Deliverable Line Items text on right vertical axis

A line plotting the completed dates for each line Item

I am not sure if I am using the wrong type of chart, need to create a pivot table, or what? 

@TecEFX From what I quickly learned on Burn Down charts, you need to calculate remaining days planned to get the work done versus actual remaining days. These values can then each be plotted on a line in time. That would be something like in the attached file. You may want to fine-tune it to your liking though.

I found quite a few examples searching, but many do not display the work items in the axis. Thanks for the suggestions.