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

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies