| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
stacked bar chart
I wish to create a horz. stacked bar chart for PC refresh cycles. (unit in
years) sample data: installed refresh refresh pc1 2002 2006 2010 pc2 2003 2007 2011 pc3 2002 2006 2010 x: axis = years y: axis = pc1,2 ,3...etc No matter how i create the chart it is always starts with 1905. is there anyway I can create a cimple and easy chart? maybe something similar to grantt chart. many thanks. Jason |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
stacked bar chart
On Wed, 30 May 2007, in microsoft.public.excel.charting,
Jason said: installed refresh refresh pc1 2002 2006 2010 pc2 2003 2007 2011 pc3 2002 2006 2010 No matter how i create the chart it is always starts with 1905. Look up "Chart Axes, scale", or similar in the Excel help file. It will show you how to set the axis scale so that it starts with 2000 instead. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
stacked bar chart
Jason said:
installed refresh refresh pc1 2002 2006 2010 pc2 2003 2007 2011 pc3 2002 2006 2010 No matter how i create the chart it is always starts with 1905. Look up "Chart Axes, scale", or similar in the Excel help file. It will show you how to set the axis scale so that it starts with 2000 instead. You also have a more serious problem: the data you have entered for the stacked bar chart implies that pc1 was installed in the year 2002, refreshed 2,006 years later, and refreshed again 2,010 years after that. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
stacked bar chart
1. Don't try to format your years as dates, because 2002 is Excel's internal
code for 24-Jun-1905 (i.e., day number 2002 after 1-Jan-1900). 2. The stacked parts of the bars need to show only the difference between the new date and the old date: PC1 2002 4 4 3. Use a regular stacked bar chart type, not the floating bar chart in the Built-In Custom collection. (With a name like "Built-In Custom", it can't be good; anyone remember "mangled baby ducks"?). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jason" wrote in message ... I wish to create a horz. stacked bar chart for PC refresh cycles. (unit in years) sample data: installed refresh refresh pc1 2002 2006 2010 pc2 2003 2007 2011 pc3 2002 2006 2010 x: axis = years y: axis = pc1,2 ,3...etc No matter how i create the chart it is always starts with 1905. is there anyway I can create a cimple and easy chart? maybe something similar to grantt chart. many thanks. Jason |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
stacked bar chart
Hi Jon Peltier,
That solution works exactly what I need. Thank you so much. Jason. "Jon Peltier" wrote: 1. Don't try to format your years as dates, because 2002 is Excel's internal code for 24-Jun-1905 (i.e., day number 2002 after 1-Jan-1900). 2. The stacked parts of the bars need to show only the difference between the new date and the old date: PC1 2002 4 4 3. Use a regular stacked bar chart type, not the floating bar chart in the Built-In Custom collection. (With a name like "Built-In Custom", it can't be good; anyone remember "mangled baby ducks"?). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jason" wrote in message ... I wish to create a horz. stacked bar chart for PC refresh cycles. (unit in years) sample data: installed refresh refresh pc1 2002 2006 2010 pc2 2003 2007 2011 pc3 2002 2006 2010 x: axis = years y: axis = pc1,2 ,3...etc No matter how i create the chart it is always starts with 1905. is there anyway I can create a cimple and easy chart? maybe something similar to grantt chart. many thanks. Jason |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
stacked bar chart
Another question..
I wish to have 2 stacked bars for each Y-axis. eg. installed refresh refresh pc1 2002 4 4 ups1 2003 4 4 pc2 2003 4 4 ups2 2004 4 4 What can I do? I have tried several options but unsuccessful. many thanks. Jason. "Jon Peltier" wrote: 1. Don't try to format your years as dates, because 2002 is Excel's internal code for 24-Jun-1905 (i.e., day number 2002 after 1-Jan-1900). 2. The stacked parts of the bars need to show only the difference between the new date and the old date: PC1 2002 4 4 3. Use a regular stacked bar chart type, not the floating bar chart in the Built-In Custom collection. (With a name like "Built-In Custom", it can't be good; anyone remember "mangled baby ducks"?). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jason" wrote in message ... I wish to create a horz. stacked bar chart for PC refresh cycles. (unit in years) sample data: installed refresh refresh pc1 2002 2006 2010 pc2 2003 2007 2011 pc3 2002 2006 2010 x: axis = years y: axis = pc1,2 ,3...etc No matter how i create the chart it is always starts with 1905. is there anyway I can create a cimple and easy chart? maybe something similar to grantt chart. many thanks. Jason |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
stacked bar chart
Check out these examples:
http://peltiertech.com/Excel/ChartsH...sterStack.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jason" wrote in message ... Another question.. I wish to have 2 stacked bars for each Y-axis. eg. installed refresh refresh pc1 2002 4 4 ups1 2003 4 4 pc2 2003 4 4 ups2 2004 4 4 What can I do? I have tried several options but unsuccessful. many thanks. Jason. "Jon Peltier" wrote: 1. Don't try to format your years as dates, because 2002 is Excel's internal code for 24-Jun-1905 (i.e., day number 2002 after 1-Jan-1900). 2. The stacked parts of the bars need to show only the difference between the new date and the old date: PC1 2002 4 4 3. Use a regular stacked bar chart type, not the floating bar chart in the Built-In Custom collection. (With a name like "Built-In Custom", it can't be good; anyone remember "mangled baby ducks"?). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jason" wrote in message ... I wish to create a horz. stacked bar chart for PC refresh cycles. (unit in years) sample data: installed refresh refresh pc1 2002 2006 2010 pc2 2003 2007 2011 pc3 2002 2006 2010 x: axis = years y: axis = pc1,2 ,3...etc No matter how i create the chart it is always starts with 1905. is there anyway I can create a cimple and easy chart? maybe something similar to grantt chart. many thanks. Jason |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ?make a combo chart with 1 stacked bar and 1 not stacked, + show t | Charts and Charting in Excel | |||
| Double-stacked Bar Chart WITH a Secondary Y Axis Line chart? | Charts and Charting in Excel | |||
| How can I combine a stacked bar chart with stacked colum chart? | Charts and Charting in Excel | |||
| To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel | |||
| How can I create a stacked bar chart with stacked bars side by | Charts and Charting in Excel | |||
Linear Mode
