| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HELP! Growth % reflected in a visual diagram
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% |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HELP! Growth % reflected in a visual diagram
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/200...a-panel-chart/ - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Flojoe" wrote in message ... 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% |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HELP! Growth % reflected in a visual diagram
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/200...a-panel-chart/ - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Flojoe" wrote in message ... 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% |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HELP! Growth % reflected in a visual diagram
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HELP! Growth % reflected in a visual diagram
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: 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HELP! Growth % reflected in a visual diagram
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" wrote in message ... 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/200...a-panel-chart/ - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Flojoe" wrote in message ... 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% |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HELP! Growth % reflected in a visual diagram
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" wrote in message ... 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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HELP! Growth % reflected in a visual diagram
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" wrote in message ... 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/200...a-panel-chart/ - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Flojoe" wrote in message ... 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% |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HELP! Growth % reflected in a visual diagram
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" wrote in message ... 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" wrote in message ... 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/200...a-panel-chart/ - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Flojoe" wrote in message ... 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% |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Result of formula reflected in Chart (Excel 2002) | Charts and Charting in Excel | |||
| Growth | Excel Worksheet Functions | |||
| input not reflected in excel | Excel Discussion (Misc queries) | |||
| Font Colors not reflected on printouts | Excel Discussion (Misc queries) | |||
| changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) | |||
Linear Mode
