Information from Spreadsheet to a Graph
 

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

Information from Spreadsheet to a Graph
 

Visit http://peltiertech.com/
then return with specific questions
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"texansgal" wrote in message
...
Is there a way to convert the information that I have from a spreadsheet
into
a graph?

Information from Spreadsheet to a Graph
 

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" wrote:

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

Information from Spreadsheet to a Graph
 

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


"texansgal" wrote:

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" wrote:

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

Information from Spreadsheet to a Graph
 

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"texansgal" wrote in message
...
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


"texansgal" wrote:

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" wrote:

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