Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I want to make a chart/graph that will have 3 columns where I can enter my
bills and have them automatically calculated. !st column the name of company, Second column amount of bill, 3rd column auto calculate my balance after each amount entered from 2nd column. Help Please!! Thanks! |
#2
![]() |
|||
|
|||
![]()
melissto wrote:
|| I want to make a chart/graph that will have 3 columns where I can || enter my bills and have them automatically calculated. !st column || the name of company, Second column amount of bill, 3rd column auto || calculate my balance after each amount entered from 2nd column. Help || Please!! Thanks! Not quite sure what you are wanting to display. Are you SURE you are wanting to make a chart? -- Interim Systems and Management Accounting Gordon Burgess-Parker Director www.gbpcomputing.co.uk |
#3
![]() |
|||
|
|||
![]() If you are talking about a simple sheet calculating the balance on a bill after a payment that's a simple thing. Have the formula in column c subtract the amount in column b from the total you owe. i.e. =(20,000-b1) =(500-b2) If you want the total of column b then you put a sum function in the cell you want the total displayed. =SUM(b1:b20) It all depends on what you are needing. Regards, Brian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I make a chart that will automatically calculate my bills . | New Users to Excel | |||
how do i make a chart using text information? | Excel Worksheet Functions | |||
How to make a stacked bar chart using time? | Charts and Charting in Excel | |||
how can I make a chart with the x-axis in logarithmic scale | Charts and Charting in Excel | |||
Make a pie chart of a budget | Charts and Charting in Excel |