![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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. |
Thread Tools | |
Display Modes | |
|
|