LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6,582
Default Subtraction Chart

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting values in a bar chart Eric D Charts and Charting in Excel 4 April 17th 06 04:44 PM
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
Urgent Chart Assistance Brent E Charts and Charting in Excel 1 May 10th 05 09:09 AM
Urgent Chart Questions Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM
Urgent Chart Assistance Requested Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM


All times are GMT +1. The time now is 05:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"