Home

7 year history chart of estimated vs actual costs

%3CLINGO-SUB%20id%3D%22lingo-sub-509445%22%20slang%3D%22en-US%22%3E7%20year%20history%20chart%20of%20estimated%20vs%20actual%20costs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-509445%22%20slang%3D%22en-US%22%3E%3CP%3EI%20took%20over%20a%20failing%20construction%20company%2014%20months%20ago%2C%20I%20have%20all%20the%20estimated%20vs%20actual%20cost%20reports%20for%20the%20past%207%20years.%20I%20want%20to%20make%20a%20chart%20showing%20this%20data%20in%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20between%2030-50%20projects%20per%20year%2C%20I%20am%20trying%20to%20show%20the%20trend%20of%20how%20we%20are%20beginning%26nbsp%3B%20to%20succeed%20vs%20the%20failures%20in%20the%20past%20on%20one%20chart.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEach%20project%20has%20estimated%20vs%20actual%20for%3A%3C%2FP%3E%3CP%3EMaterials%3C%2FP%3E%3CP%3ELabor%3C%2FP%3E%3CP%3EOther%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20do%20this%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-509445%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-510443%22%20slang%3D%22en-US%22%3ERe%3A%207%20year%20history%20chart%20of%20estimated%20vs%20actual%20costs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-510443%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F331551%22%20target%3D%22_blank%22%3E%40Superoofer%3C%2FA%3E%26nbsp%3B.%20Load%20file%20here%20then%20you%20will%20receive%20lots%20of%20support.%20J%3C%2FP%3E%3C%2FLINGO-BODY%3E
Superoofer
Occasional Visitor

I took over a failing construction company 14 months ago, I have all the estimated vs actual cost reports for the past 7 years. I want to make a chart showing this data in Excel.

 

I have between 30-50 projects per year, I am trying to show the trend of how we are beginning  to succeed vs the failures in the past on one chart. 

 

Each project has estimated vs actual for:

Materials

Labor

Other

 

How do I do this? 

 

Thanks

1 Reply

@Superoofer . Load file here then you will receive lots of support. J