Information from Spreadsheet to a Graph

  • Thread starter Thread starter Guest
  • Start date Start date
I have a P&L Spreadsheet that has the GL item listed on the left in rows.
Then in columns, I have the amounts whether they are positive or negative. I
want to build a graph off of this information to show how we made or lost
money on each item each month for 12 months.
 
Here is how it looks (only it is in columns):

R&M Autombile/Trucks 813.75
Award & Incentives - Safety 1,234.30
Boat Repairs and Supplies 0.00
Communications - Indirect:Beep 0.00
Communications - Indirect:Cell 456.62
Equip Repairs 1,021.36
Gas/Fuel - Trucks 7,917.75
In-Job Cst:Freight and Shippin 133.18
In-Job Cst:IDE - Indirect Equi 1,616.72
In Job Cst IDS - Supply & Incd 6,311.90
In-Job Cst: Safety Supplies 8,236.01
Labor Indirect:Operations 16,646.24
Labor Indirect OT 169.88
Medical Services 1,046.00
Repairs Vac Trucks 0.00
Tolls 252.00
Trailer Repairs and Maintenanc 896.93
Training Operations 372.00
Uniforms 2,071.74
Vehicle Leases 27,590.50
Labor - Vacation, Sick, Other 3,377.74
Labor Indirect:Payroll Taxes-I 5,774.87
Emp Ben:Group Dental Insurance (184.43)
Emp Ben:Group Medical Insuranc (1,270.90)
Employment Expenses 0.00
Indirect Cost Incurred 84,484.16

Allocated Indirect Cost
Allocated Div Indirect Cost (20,663.49)
Allocation of Employee Benefits to Projects (11,230.20)
Allocate Branch Indirect Cost to Division 0.00
Total Allocated Indirect Cost (31,893.69)

NET INDIRECT COST 52,590.47
 
Select the range of data, start the chart wizard (Insert menu > Chart, if
you can't find the right button on the toolbar), and make a bar chart. Does
this help at all?

- Jon
 
Back
Top