Information from Spreadsheet to a Graph

[texansgal]

Is there a way to convert the information that I have from a spreadsheet into
a graph?

 

[Bernard Liengme]

Visit http://peltiertech.com/
then return with specific questions
best wishes

 

[texansgal]

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.

 

[texansgal]

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 Indirectayroll 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

 

[Jon Peltier]

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