Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Don't bother. A great many of us still use text-based readers without all
the glitzy bells and whistles. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Bunnie" wrote in message ... Thank you. Unfortunately I am very new to this group and do not know how to rate a post. -- Busy Bunnie "David Biddulph" wrote: You say you are working across the chart, but the references you've given are all down one column. In C15, use the formula =C1-SUM(C2:C5) [or =C1-SUM(C2:C14) if you may want to put extra debit items in C6 to C14]. -- David Biddulph "Bunnie" wrote in message ... I want to create a chart with a major number, then input various debit amounts in the next cells across and end with a final cell showing the balance left. I have tried "sum" but have not been successful. I work across the chart not down. Example in C1 entered $2000 as opening amount, then subtract from C2 $225, C3 $150, C4 $467, C5 $825. C 15 should then show a remaining balance of $333. -- Busy Bunnie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting values in a bar chart | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) |