Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can anyone help with this chart?
I would like to have the following values/labels on the y and x axis of any
style of chart: X-axis: July, August, September etc for a full financial year; Y-axis: FB, AP, DR, LA, PC. OR the other way around. Presently the Y-axis simply displays the labels 'Jan Jan Jan Jan Jan' etc. Thank you. Any help would be much appreciated. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can anyone help with this chart?
Check out Jon Peltier's article on creating a vertical category axis:
http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "A little stuck" wrote: I would like to have the following values/labels on the y and x axis of any style of chart: X-axis: July, August, September etc for a full financial year; Y-axis: FB, AP, DR, LA, PC. OR the other way around. Presently the Y-axis simply displays the labels 'Jan Jan Jan Jan Jan' etc. Thank you. Any help would be much appreciated. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can anyone help with this chart?
Are the Y "values" some kind of rating? Where do the points go? What do
they show? - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ A little stuck wrote: I would like to have the following values/labels on the y and x axis of any style of chart: X-axis: July, August, September etc for a full financial year; Y-axis: FB, AP, DR, LA, PC. OR the other way around. Presently the Y-axis simply displays the labels 'Jan Jan Jan Jan Jan' etc. Thank you. Any help would be much appreciated. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can anyone help with this chart?
Thank you.
The Y "values" (FB, AP, DR, LA, PC) are milestones - certain stages of a project. The points will show in which month each milestone is achieved. I am hoping to have two series lines - one showing the original forecast for the milestones, and one showing the actual months in which the milestones were achieved. "Jon Peltier" wrote: Are the Y "values" some kind of rating? Where do the points go? What do they show? - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ A little stuck wrote: I would like to have the following values/labels on the y and x axis of any style of chart: X-axis: July, August, September etc for a full financial year; Y-axis: FB, AP, DR, LA, PC. OR the other way around. Presently the Y-axis simply displays the labels 'Jan Jan Jan Jan Jan' etc. Thank you. Any help would be much appreciated. |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can anyone help with this chart?
Tis is more of a gantt chart then, isn't it? You could make a gantt type
chart, with your milestones as the tasks in the chart forecast as start date and actual as finish, where the length of the bar indicates the amount of slippage. Maybe do a fancier one with red bars for slippage and blue for finishing early. Gantt Charts in Microsoft Excel http://pubs.logicalexpressions.com/P...cle.asp?ID=343 Advanced Gantt Charts in Microsoft Excel http://peltiertech.com/Excel/Charts/GanttChart.html You could also use a dot plot to display this data: Dot Plots - http://peltiertech.com/Excel/Charts/DotPlot.html - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ A little stuck wrote: Thank you. The Y "values" (FB, AP, DR, LA, PC) are milestones - certain stages of a project. The points will show in which month each milestone is achieved. I am hoping to have two series lines - one showing the original forecast for the milestones, and one showing the actual months in which the milestones were achieved. "Jon Peltier" wrote: Are the Y "values" some kind of rating? Where do the points go? What do they show? - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ A little stuck wrote: I would like to have the following values/labels on the y and x axis of any style of chart: X-axis: July, August, September etc for a full financial year; Y-axis: FB, AP, DR, LA, PC. OR the other way around. Presently the Y-axis simply displays the labels 'Jan Jan Jan Jan Jan' etc. Thank you. Any help would be much appreciated. |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can anyone help with this chart?
Thank you very much for your help, problem solved :)
"Jon Peltier" wrote: Tis is more of a gantt chart then, isn't it? You could make a gantt type chart, with your milestones as the tasks in the chart forecast as start date and actual as finish, where the length of the bar indicates the amount of slippage. Maybe do a fancier one with red bars for slippage and blue for finishing early. Gantt Charts in Microsoft Excel http://pubs.logicalexpressions.com/P...cle.asp?ID=343 Advanced Gantt Charts in Microsoft Excel http://peltiertech.com/Excel/Charts/GanttChart.html You could also use a dot plot to display this data: Dot Plots - http://peltiertech.com/Excel/Charts/DotPlot.html - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ A little stuck wrote: Thank you. The Y "values" (FB, AP, DR, LA, PC) are milestones - certain stages of a project. The points will show in which month each milestone is achieved. I am hoping to have two series lines - one showing the original forecast for the milestones, and one showing the actual months in which the milestones were achieved. "Jon Peltier" wrote: Are the Y "values" some kind of rating? Where do the points go? What do they show? - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ A little stuck wrote: I would like to have the following values/labels on the y and x axis of any style of chart: X-axis: July, August, September etc for a full financial year; Y-axis: FB, AP, DR, LA, PC. OR the other way around. Presently the Y-axis simply displays the labels 'Jan Jan Jan Jan Jan' etc. Thank you. Any help would be much appreciated. |
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can anyone help with this chart?
Thank you very much for your help, problem solved :)
"Jon Peltier" wrote: Tis is more of a gantt chart then, isn't it? You could make a gantt type chart, with your milestones as the tasks in the chart forecast as start date and actual as finish, where the length of the bar indicates the amount of slippage. Maybe do a fancier one with red bars for slippage and blue for finishing early. Gantt Charts in Microsoft Excel http://pubs.logicalexpressions.com/P...cle.asp?ID=343 Advanced Gantt Charts in Microsoft Excel http://peltiertech.com/Excel/Charts/GanttChart.html You could also use a dot plot to display this data: Dot Plots - http://peltiertech.com/Excel/Charts/DotPlot.html - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ A little stuck wrote: Thank you. The Y "values" (FB, AP, DR, LA, PC) are milestones - certain stages of a project. The points will show in which month each milestone is achieved. I am hoping to have two series lines - one showing the original forecast for the milestones, and one showing the actual months in which the milestones were achieved. "Jon Peltier" wrote: Are the Y "values" some kind of rating? Where do the points go? What do they show? - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ A little stuck wrote: I would like to have the following values/labels on the y and x axis of any style of chart: X-axis: July, August, September etc for a full financial year; Y-axis: FB, AP, DR, LA, PC. OR the other way around. Presently the Y-axis simply displays the labels 'Jan Jan Jan Jan Jan' etc. Thank you. Any help would be much appreciated. |
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can anyone help with this chart?
Tis is more of a gantt chart then, isn't it? You could make a gantt type
chart, with your milestones as the tasks in the chart forecast as start date and actual as finish, where the length of the bar indicates the amount of slippage. Maybe do a fancier one with red bars for slippage and blue for finishing early. Gantt Charts in Microsoft Excel http://pubs.logicalexpressions.com/P...cle.asp?ID=343 Advanced Gantt Charts in Microsoft Excel http://peltiertech.com/Excel/Charts/GanttChart.html You could also use a dot plot to display this data: Dot Plots - http://peltiertech.com/Excel/Charts/DotPlot.html - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ A little stuck wrote: Thank you. The Y "values" (FB, AP, DR, LA, PC) are milestones - certain stages of a project. The points will show in which month each milestone is achieved. I am hoping to have two series lines - one showing the original forecast for the milestones, and one showing the actual months in which the milestones were achieved. "Jon Peltier" wrote: Are the Y "values" some kind of rating? Where do the points go? What do they show? - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ A little stuck wrote: I would like to have the following values/labels on the y and x axis of any style of chart: X-axis: July, August, September etc for a full financial year; Y-axis: FB, AP, DR, LA, PC. OR the other way around. Presently the Y-axis simply displays the labels 'Jan Jan Jan Jan Jan' etc. Thank you. Any help would be much appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change Chart Properties for Multiple Chart Shts using a Worksheet | Charts and Charting in Excel | |||
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard | Charts and Charting in Excel | |||
Excel 2003 is missing Built-In Custom Chart Types in Chart Wizard | Setting up and Configuration of Excel | |||
Creating a chart(? pie chart) that shows customers,dates and machi | Charts and Charting in Excel | |||
Double-stacked Bar Chart WITH a Secondary Y Axis Line chart? | Charts and Charting in Excel |