HELP! Growth % reflected in a visual diagram Flojoe 12/29/2008 8:35:01 PM I have the data but do not know how to show it in a visual scatter gram or smokestacks or anything? What I would like to show is how in the last 3 years we SOWs have increased (a lot) and the revenue has doubled in the last 2 years -- I really want to make sure that they can see the 92% & 95% growth & see the add'l work efforts that need to be applied -- PLEASE HELP me to show that in a visual -- THANK YOU!!! SecureCode SOWs 2006 2007 2008 SOW Count 4 16 45 SOW Revenue $93,500 $179,600 $351,400 SOW Growth 92.08% 95.65%

Re: HELP! Growth % reflected in a visual diagram "Jon Peltier" <jonxlmvpNO[ at ]SPAMpeltiertech.com> 12/29/2008 11:37:16 PM FloJoe - I've built a panel chart to handle your data. It will be available by morning on my blog, at http://peltiertech.com/WordPress/2008/12/30/growth-rates-in-a-panel-chart/ - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Flojoe" <Flojoe[ at ]discussions.microsoft.com> wrote in message news:6657E125-4261-4D21-A022-B5974B80F2B1[ at ]microsoft.com... [Quoted Text] >I have the data but do not know how to show it in a visual scatter gram or > smokestacks or anything? What I would like to show is how in the last 3 > years we SOWs have increased (a lot) and the revenue has doubled in the > last > 2 years -- I really want to make sure that they can see the 92% & 95% > growth > & see the add'l work efforts that need to be applied -- PLEASE HELP me to > show that in a visual -- THANK YOU!!! > > SecureCode SOWs 2006 2007 2008 > SOW Count 4 16 45 > SOW Revenue $93,500 $179,600 $351,400 > SOW Growth 92.08% 95.65% >

Re: HELP! Growth % reflected in a visual diagram fkistner 12/30/2008 3:04:01 AM Hi Jon: your link to get a feel for this site and received this error message: Error 404 - Page not found! The page you trying to reach does not exist, or has been moved. Perhaps you can find what you are looking for by searching the site archives. I sure appreciate your help -- thanks! Flojoe -- flojoe "Jon Peltier" wrote: [Quoted Text] > FloJoe - > > I've built a panel chart to handle your data. It will be available by > morning on my blog, at > http://peltiertech.com/WordPress/2008/12/30/growth-rates-in-a-panel-chart/ > > - Jon > ------- > Jon Peltier, Microsoft Excel MVP > Peltier Technical Services, Inc. > http://PeltierTech.com/WordPress/ > _______ > > > "Flojoe" <Flojoe[ at ]discussions.microsoft.com> wrote in message > news:6657E125-4261-4D21-A022-B5974B80F2B1[ at ]microsoft.com... > >I have the data but do not know how to show it in a visual scatter gram or > > smokestacks or anything? What I would like to show is how in the last 3 > > years we SOWs have increased (a lot) and the revenue has doubled in the > > last > > 2 years -- I really want to make sure that they can see the 92% & 95% > > growth > > & see the add'l work efforts that need to be applied -- PLEASE HELP me to > > show that in a visual -- THANK YOU!!! > > > > SecureCode SOWs 2006 2007 2008 > > SOW Count 4 16 45 > > SOW Revenue $93,500 $179,600 $351,400 > > SOW Growth 92.08% 95.65% > > > > >

Re: HELP! Growth % reflected in a visual diagram Herbert Seidenberg <herbds7-msxls[ at ]yahoo.com> 12/30/2008 3:07:08 AM Revenues per count are actually declining. Assuming that exponential growth is not sustainable, and that expenses are proportional to the count, then you should be out of business by 2011. http://www.mediafire.com/file/m4nnlttqz5o/12_29_08.xlsx

Re: HELP! Growth % reflected in a visual diagram fkistner 12/30/2008 3:45:01 AM Sorry Herbert but the link you provided I could not access -- I joined as a free member and still could not access this link -- your assistance would be wonderful. Thank you! Flojoe -- flojoe "Herbert Seidenberg" wrote: [Quoted Text] > Revenues per count are actually declining. > Assuming that exponential growth is not sustainable, > and that expenses are proportional to the count, > then you should be out of business by 2011. > http://www.mediafire.com/file/m4nnlttqz5o/12_29_08.xlsx >

Re: HELP! Growth % reflected in a visual diagram "Jon Peltier" <jonxlmvpNO[ at ]SPAMpeltiertech.com> 12/30/2008 3:45:50 PM The link is now available. I didn't publish until this morning, because I hadn't finished the article. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "fkistner" <fkistner[ at ]discussions.microsoft.com> wrote in message news:4E939F8C-B94D-4317-A265-B093F0554F08[ at ]microsoft.com... [Quoted Text] > Hi Jon: > > your link to get a feel for this site and received this error message: > > Error 404 - Page not found! > The page you trying to reach does not exist, or has been moved. Perhaps > you > can find what you are looking for by searching the site archives. > > I sure appreciate your help -- thanks! > > Flojoe > > -- > flojoe > > > "Jon Peltier" wrote: > >> FloJoe - >> >> I've built a panel chart to handle your data. It will be available by >> morning on my blog, at >> http://peltiertech.com/WordPress/2008/12/30/growth-rates-in-a-panel-chart/ >> >> - Jon >> ------- >> Jon Peltier, Microsoft Excel MVP >> Peltier Technical Services, Inc. >> http://PeltierTech.com/WordPress/ >> _______ >> >> >> "Flojoe" <Flojoe[ at ]discussions.microsoft.com> wrote in message >> news:6657E125-4261-4D21-A022-B5974B80F2B1[ at ]microsoft.com... >> >I have the data but do not know how to show it in a visual scatter gram >> >or >> > smokestacks or anything? What I would like to show is how in the last >> > 3 >> > years we SOWs have increased (a lot) and the revenue has doubled in the >> > last >> > 2 years -- I really want to make sure that they can see the 92% & 95% >> > growth >> > & see the add'l work efforts that need to be applied -- PLEASE HELP me >> > to >> > show that in a visual -- THANK YOU!!! >> > >> > SecureCode SOWs 2006 2007 2008 >> > SOW Count 4 16 45 >> > SOW Revenue $93,500 $179,600 $351,400 >> > SOW Growth 92.08% 95.65% >> > >> >> >>

Re: HELP! Growth % reflected in a visual diagram "Jon Peltier" <jonxlmvpNO[ at ]SPAMpeltiertech.com> 12/30/2008 4:03:47 PM Revenues per count are exponentially decaying, and an unscientific case can be made that this figure is asymptotically approaching $6000 per unit. In some situations, this may be good, for example, if SOW refers to projects undertaken for a given client, more smaller projects means that cancellation of a project by one client will have less of an effect on revenues, costs, resource deployment, etc. However, I know nothing about these numbers, so I am only guessing. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Herbert Seidenberg" <herbds7-msxls[ at ]yahoo.com> wrote in message news:88282e2d-5127-4077-a392-05a68444a194[ at ]w1g2000prm.googlegroups.com... [Quoted Text] > Revenues per count are actually declining. > Assuming that exponential growth is not sustainable, > and that expenses are proportional to the count, > then you should be out of business by 2011. > http://www.mediafire.com/file/m4nnlttqz5o/12_29_08.xlsx

Re: HELP! Growth % reflected in a visual diagram fkistner 12/30/2008 8:08:29 PM Was a bit of a challenge but I think it looks great -- the only minor item is I can't get the 2006, 2007, 2008 to be at the bottom like you show them what am I not doing? Thanks! -- flojoe "Jon Peltier" wrote: [Quoted Text] > The link is now available. I didn't publish until this morning, because I > hadn't finished the article. > > - Jon > ------- > Jon Peltier, Microsoft Excel MVP > Peltier Technical Services, Inc. > http://PeltierTech.com/WordPress/ > _______ > > > "fkistner" <fkistner[ at ]discussions.microsoft.com> wrote in message > news:4E939F8C-B94D-4317-A265-B093F0554F08[ at ]microsoft.com... > > Hi Jon: > > > > your link to get a feel for this site and received this error message: > > > > Error 404 - Page not found! > > The page you trying to reach does not exist, or has been moved. Perhaps > > you > > can find what you are looking for by searching the site archives. > > > > I sure appreciate your help -- thanks! > > > > Flojoe > > > > -- > > flojoe > > > > > > "Jon Peltier" wrote: > > > >> FloJoe - > >> > >> I've built a panel chart to handle your data. It will be available by > >> morning on my blog, at > >> http://peltiertech.com/WordPress/2008/12/30/growth-rates-in-a-panel-chart/ > >> > >> - Jon > >> ------- > >> Jon Peltier, Microsoft Excel MVP > >> Peltier Technical Services, Inc. > >> http://PeltierTech.com/WordPress/ > >> _______ > >> > >> > >> "Flojoe" <Flojoe[ at ]discussions.microsoft.com> wrote in message > >> news:6657E125-4261-4D21-A022-B5974B80F2B1[ at ]microsoft.com... > >> >I have the data but do not know how to show it in a visual scatter gram > >> >or > >> > smokestacks or anything? What I would like to show is how in the last > >> > 3 > >> > years we SOWs have increased (a lot) and the revenue has doubled in the > >> > last > >> > 2 years -- I really want to make sure that they can see the 92% & 95% > >> > growth > >> > & see the add'l work efforts that need to be applied -- PLEASE HELP me > >> > to > >> > show that in a visual -- THANK YOU!!! > >> > > >> > SecureCode SOWs 2006 2007 2008 > >> > SOW Count 4 16 45 > >> > SOW Revenue $93,500 $179,600 $351,400 > >> > SOW Growth 92.08% 95.65% > >> > > >> > >> > >> > > >

Re: HELP! Growth % reflected in a visual diagram "Jon Peltier" <jonxlmvpNO[ at ]SPAMpeltiertech.com> 12/31/2008 4:21:04 PM Format the category axis, and on the patterns tab (Excel 2003 & earlier) choose Low for Axis Labels. In 2007 I think this is on the first tab when you format the axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "fkistner" <fkistner[ at ]discussions.microsoft.com> wrote in message news:043ED7BB-3625-4A22-A922-39A144573175[ at ]microsoft.com... [Quoted Text] > Was a bit of a challenge but I think it looks great -- the only minor item > is > I can't get the 2006, 2007, 2008 to be at the bottom like you show them > what > am I not doing? Thanks! > -- > flojoe > > > "Jon Peltier" wrote: > >> The link is now available. I didn't publish until this morning, because I >> hadn't finished the article. >> >> - Jon >> ------- >> Jon Peltier, Microsoft Excel MVP >> Peltier Technical Services, Inc. >> http://PeltierTech.com/WordPress/ >> _______ >> >> >> "fkistner" <fkistner[ at ]discussions.microsoft.com> wrote in message >> news:4E939F8C-B94D-4317-A265-B093F0554F08[ at ]microsoft.com... >> > Hi Jon: >> > >> > your link to get a feel for this site and received this error message: >> > >> > Error 404 - Page not found! >> > The page you trying to reach does not exist, or has been moved. Perhaps >> > you >> > can find what you are looking for by searching the site archives. >> > >> > I sure appreciate your help -- thanks! >> > >> > Flojoe >> > >> > -- >> > flojoe >> > >> > >> > "Jon Peltier" wrote: >> > >> >> FloJoe - >> >> >> >> I've built a panel chart to handle your data. It will be available by >> >> morning on my blog, at >> >> http://peltiertech.com/WordPress/2008/12/30/growth-rates-in-a-panel-chart/ >> >> >> >> - Jon >> >> ------- >> >> Jon Peltier, Microsoft Excel MVP >> >> Peltier Technical Services, Inc. >> >> http://PeltierTech.com/WordPress/ >> >> _______ >> >> >> >> >> >> "Flojoe" <Flojoe[ at ]discussions.microsoft.com> wrote in message >> >> news:6657E125-4261-4D21-A022-B5974B80F2B1[ at ]microsoft.com... >> >> >I have the data but do not know how to show it in a visual scatter >> >> >gram >> >> >or >> >> > smokestacks or anything? What I would like to show is how in the >> >> > last >> >> > 3 >> >> > years we SOWs have increased (a lot) and the revenue has doubled in >> >> > the >> >> > last >> >> > 2 years -- I really want to make sure that they can see the 92% & >> >> > 95% >> >> > growth >> >> > & see the add'l work efforts that need to be applied -- PLEASE HELP >> >> > me >> >> > to >> >> > show that in a visual -- THANK YOU!!! >> >> > >> >> > SecureCode SOWs 2006 2007 2008 >> >> > SOW Count 4 16 45 >> >> > SOW Revenue $93,500 $179,600 $351,400 >> >> > SOW Growth 92.08% 95.65% >> >> > >> >> >> >> >> >> >> >> >>