Charting Beginning Revenue and Changes Over a 12 year period

Hi

I would like to create a chart that shows revenue for 1996 and cumulative 
year over year changes in revenue that when added to 1996 (beginning balance) 
will equal 2008.  

Does a particular chart come to mind?

Thanks in advance.

Al Charbonneau
0
Utf
2/26/2010 3:59:01 PM
excel.charting 18370 articles. 0 followers. Follow

1 Replies
552 Views

Similar Articles

[PageSpeed] 14

Waterfall?

http://peltiertech.com/Excel/Charts/ChartIndex.html#Waterfall

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 2/26/2010 10:59 AM, Al Charbonneau wrote:
> Hi
>
> I would like to create a chart that shows revenue for 1996 and cumulative
> year over year changes in revenue that when added to 1996 (beginning balance)
> will equal 2008.
>
> Does a particular chart come to mind?
>
> Thanks in advance.
>
> Al Charbonneau
0
Jon
3/1/2010 1:25:06 PM
Reply:

Similar Artilces:

Log changes to full access permission
Exchange 2007 SP1. Is there a log, or is it possible to log, whenever anyone is granted full access to a mailbox or mailboxes? Thank you. Adrian What do you mean by "anyone"? Please make your request more specific. -- Ed Crowley MVP "There are seldom good technological solutions to behavioral problems." .. "Adrian" <NoSpam@Hotmail.com> wrote in message news:%23eQ58rEaKHA.1640@TK2MSFTNGP06.phx.gbl... > Exchange 2007 SP1. > > Is there a log, or is it possible to log, whenever anyone is granted full > access to a ma...

How to change the return of a textbox from TRUE/FALSE to YES/NO?
I have a long colum full of textboxes in excel. When the boc is checked it returns true, and false for unchecked. I would like to change this so that it returns Yes for checked and No for unchecked. How can I make this happen You mean Checkboxes? You can use a helper cell: =if(a1=true,"Yes","No") Then hide that linkedcell (if you want). Gldenboy2 wrote: > > I have a long colum full of textboxes in excel. When the boc is checked it > returns true, and false for unchecked. I would like to change this so that > it returns Yes for checked and No for un...

pivot chart, mean and standard error
hello, I'm using a pivot table to calculate the mean and the stdevp of values collected in different condition. My problem is to draw the corresponding chart for the means of the values, and using the stdevp values for the error bars. Using a stacked histogram, I have something which resembles to what I would like but I would prefer to have a classical error bar. Is there a way to manage ? I want to keep something automatic and not static, with a copy/paste values to draw manually my charts. Thanks for your help -- Misange migrateuse http://www.excelabo.net mail : http://cerbermail.c...

How to change The height of the Split Window in a frame?
Hi: Every one, I make a 2-rows , 1 col CSplitterWnd i n a frame, Now i want to hide one of them, Or change the height of the window to 0, How to do,? Thanks Hi Jerry, Check SetRowInfo() and RecalcLayout() Normand "Jerry" <tghu@163.net> a �crit dans le message de news: eCW9GVIoEHA.644@tk2msftngp13.phx.gbl... > Hi: > Every one, > I make a 2-rows , 1 col CSplitterWnd i n a frame, > Now i want to hide one of them, > Or change the height of the window to 0, > How to do,? > Thanks > > > ...

Excel asking for save with no changes #5
Dave Peterson Wrote: > And xl2002 added an option that allows you to have more control: > Edit|links|startup prompt button. > check the "don't display the alert and update links" This sounds like exactly what I'm looking for! Unfortunately, I' running an older version of Excel. I'll have to hit up my IT perso for an update. Thanks! -Tomm -- tommy2 ----------------------------------------------------------------------- tommy20's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=281 View this thread: http://www.excelforum.com/sh...

Stacked Line Chart
I have a chart that is predominately a stacked bar chart however I want to have 3 sections as a stacked line chart as the represent hours for the whole group. I can sucessfully set it for 2 stacked lines but when I add the 3rd line if it has either a blank or 0 in the cell it picks up the line from the previous stacked line. Is it possible to have 3 stacked lines? Sure it's possible, but I don't know what you mean, "it picks up the line from the previous stacked line". Stacked means each line's value is added to the previous total, so if the value of the third it...

How Change default "look in" location in EXCEL for Importing Exte.
I am importing data contained in a text file. When I get to Import Data, the "Look In" folder location always defaults to "My Data Sources". How do I change that to the folder where my data is? (files are on my computer). thanks ...

New Chart in Excel 2007 is NOT showed unless preview
I have a sheet with multiple charts in Excel 2007 one of the new created charts is hidden when I open the file Unless preview is selected, then finally turned on BUT many formats are changed and objects on charts (titles,...) can not be moved ! what's wrong ? Make sure you have installed SP2 for Office 2007 as this fixes some (not all) chart problems best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Rolando" <Rolando@discussions.microsoft.com> wrote in message news:0B0A3E5C-AABD-4982-962B-8C5C09A2CC5A@microsoft...

How do I create an area and line combination chart?
I want tocreate a combination chart, using the chart types area and line, it is not listed as a custom type in Excel - is it possible? Hi, Ignore the built-in combinations and create your own. Start with creating a Line chart with your data. Then select the line series that you want as an area chart. Right click and pick Chart Type to select the required Area chart type. Cheers Andy Nuala wrote: > I want tocreate a combination chart, using the chart types area and line, it > is not listed as a custom type in Excel - is it possible? -- Andy Pope, Microsoft MVP - Excel http://ww...

Track Changes Query
Hi I wonder if someone could help me please with a problem that's been baffling for a few weeks now. I am trying to create a query, which in turn feeds a report, that shows tracked changes. I have previously posted on this forum and got some great advice that's really helped me along but I'm really struggling with the query to extract the data. I am relatively new to Access in particular VBA but I am willing to learn. What I would like to do is to use a date parameter to extract those fields with an updated time stamp within a given time period, which in turn I can sho...

How can I change background color of DateTimePicker?
I know that subj is possible because of Borland C++ Builder allow to change background color of DateTimePicker just assigning a color to Color property of TDateTimePicker component. When I try to make this subj using MFC I've got nothing. Can anybody help me? My code : m_date.Create(WS_CHILD | WS_VISIBLE | DTS_SHORTDATEFORMAT, CRect(36, 0, 116, topHeight), this, 1006); m_date.SetFormat("dd.MM.yyyy"); m_date.Invalidate(TRUE); CDC *dc=m_date.GetDC(); assert(dc->SelectObject(&greenBrush)); ReleaseDC(dc); With best regards, Sergiy Yakovyn. "Sergiy ...

Change size of name box
This is a multi-part message in MIME format. ------=_NextPart_000_003C_01C3D233.5A184190 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is it possible to change the size of the name box ? And how do you do it = ? Some of my range's names are to long to fit in the actual name box. Thanks in Advance, and may all of you have a healthy 2004 Gilbert ------=_NextPart_000_003C_01C3D233.5A184190 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HT...

changed time and date and messed up appointments
Hi I recently went to UK from Australia, then to italy, I must have changed the time zones, and now my appointments are all over the place, Is there a way of getting them back to original times and dates. for the future is there a better way of handling time zones. i also use a pocket pc where i probably changed zones as well. thanks tim See the following MSKB article for a workaround: http://support.microsoft.com/?kbid=197480 -- Jocelyn Fiorello MVP - Outlook *** Messages sent to my e-mail address will NOT be answered -- please reply only to the newsgroup to preserve the mes...

Stock High-Low-Close Chart
Is it possible to produce a Hi-Lo-Close chart with reversed axes - ie with the Hi-Lo bars horizontal rather than vertical? The normal HLC chart has stocks listed along the x axis and price up the y axis. How would I switch this around? I want to display a series of stocks listed down the y axis and the hilo price range given across the x-axis. Thanks for any advice on this. Tim, Assuming your data is first set up like this and cover the range A1:D8: High Close Low Conoco 41 39.5 38 Exxon 42 40.5 39 Shell 41 39.5 38 Baker 40 38.5 37 Halliburton 39 37.5 36 Marathon 40 38.5 37 Diamond 40...

Change to foreign currency in POS 1.0 SP 1a
I am new to MS Dynamics POS and would appreciate assistance in changing the default currency from US$ to Nigeria currency. Simply, I would like the $ symbol change to N. Thanking you for your assistance. Thank you folks. I found the answer in Junaid Idrees'response to Tim Simth's post on 7/24/06. "Sokan33" wrote: > I am new to MS Dynamics POS and would appreciate assistance in changing the > default currency from US$ to Nigeria currency. Simply, I would like the $ > symbol change to N. > > Thanking you for your assistance. ...

Year + week => first date of week
Hi, I would like Excel to calculate the date for the first day (Monday) in a week.I have my sheet setup like this: Cell = A1 = Year = 2009 Cell = A2 = Week = 32 Cell = A3 =DATE(A3,1,1)+7*B3 this gives me the Excel date = 40038 (2009-08-13 Thursday) this is not correct. Correct Excel date for 2009 week 32 should be 40028 (2008-08-03 Monday). I live in Sweden and we use the ISO week that starts on Mondays (first week of the new year is the first week that contains Thursday). I don't know if it has got something to do with that the formula above does not work. Above formula is the one I ...

Opportunities & Opportunity Products 12-02-05
Two Questions: Is there a way in CRM to copy an Opportunity from one Account to another? If not, is there a third-party add-on that provides this ability? Is there a way in CRM to select and add multiple products to an Opportunity instead of selecting them from the price list one at a time? If not, is there a third-party add-on that provides this ability? While these features do not exist there are many ISV's on this group who could write them for you at a price.. Its all down to how much these features are worth to you ========================= John O'Donnell Microsoft CRM...

Payee change
Not sure how it happened but my version of Money changed the name of my mortgage payee to another. This affected all my loan payments dating back 5+ years. This entry is generated by a auto bill viewable in bill summary. I fixed the future transaction by editing the bill but all the prior payments are wrong. Is there any way to change this as a batch instead of each transaction? This is very time consuming. Thanks... & Happy New year In microsoft.public.money, SCOTT wrote: >Not sure how it happened but my version of Money changed the name of my >mortgage payee to...

Stop Chart Style (Format) Update
Hi TWIMC, I'm using Excel 2000 and I have a pivot table that aggregates data based on REGION, COUNTRY, ZONE etc etc. Once I have set up the chart they way that I would like it to look, if I then make a change to the selection using the pivot chart buttons, e.g. I select a country and the chart re-formats itself back to what appears to be the default style. I've set my chart style to the default but it still doesn't keep my chart style. What I want is that the chart style remains the same but the new values are just plotted onto the chart. I'm sure there is an option to turn ...

changing character set of a dialog control
Does somebody know how can I dynamically change a character set that a control in my dialog uses? Thanks! >Does somebody know how can I dynamically change a >character set that a control in my dialog uses? I suspect you're looking for SetFont (WM_SETFONT) Dave -- MVP VC++ FAQ: http://www.mvps.org/vcfaq Hi, I tried the following: CFont font; VERIFY(font.CreateFont( 33, // nHeight 0, // nWidth 0, // nEscapement 0, // nOrientation FW_NORMAL, // nWeight...

Remove Spaces beginning Time entry
I am using "=TIME(HOUR(B11),MROUND(MINUTE(B11),I11),0)" for a time card, but if a space is entered we get #VALUE error. How can these spaces be filtered out. Input "06:00" or "06:00 am" works, but " 06:00" gives #VALUE error. Thanks Jack Have a look at TimeValue in help. "Jack Bible" <jbible@bellsouth.net> wrote in message news:42B44038.3DE13425@bellsouth.net... > I am using "=TIME(HOUR(B11),MROUND(MINUTE(B11),I11),0)" for > a time card, but if a space is entered we get #VALUE error. How can > these spaces be filt...

Change Y axes (Categories) on line chart
I have a line chart. I am happy with my X axis categories, which say something like "Term 1", "Term 2", "Term 3" etc However my Y axis reflects the actual values (eg Points scored) that I wish to chart, whereas I want it to contain descriptive terms such as "Grade C", "Grade B" etc I have read Jon Peltier on how to change axis by creating a dummy series in a scatter graph. Problem is that if I change to a scatter chart, I lose my X axis.values that I am happy with. I suppose that I could then fix this by using Jon's solution twice: o...

How do print a chart with smooth lines?
I am trying to paste a pie chart in PowerPoint and print a pie chart with smooth edges. Does anyone know how this is done? Thanks I've got the same question. Is there any way to smooth the lines? "AmyC79" wrote: > I am trying to paste a pie chart in PowerPoint and print a pie chart with > smooth edges. Does anyone know how this is done? > > Thanks The only workaround I could come up with was to draw an elipse over the pie chart. I set the color in the middle of the elipe to no fill and made the line thickness "2" to cover the jagged pie circle....

Sparkline Charts
Hi, How can i create sparkline charts in excel 2003 Hi, To do it easily, you'll need to dowload one of the many add-ins available. With a bit of fiddlinh, you can generate some chart types which can be made small enough to fit in a single, slightly enlarged cell. Another way is to use a panel chart. Dave "Raiju" wrote: > Hi, > > How can i create sparkline charts in excel 2003 You can use the free Excel add-in I created. Download and examples files are available at http://sparklines-excel.blogspot.com/. Sparklines for excel is an open source project hosted by S...

SALESRCT journal entries posting to wrong period
This has been happening quite often since upgrading to version 10. After we close a month and re-open a new one, we have found many incidences of SALESRCT journal entries that have posted to the previous month AFTER it was closed, thus causing many accounting headaches. If I take one as an example, the source doc shows GL, with reference SALESRCT083898. It was an inventory and a COGS adjustment, which means it originated from sales, but the user that posted, is showing the AP clerk. I assume this is due to an invoice posting with a cost variance for an item that was already...