Can anyone help with this chart?

  • Thread starter Thread starter A little stuck
  • Start date Start date
A

A little stuck

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.
 
Are the Y "values" some kind of rating? Where do the points go? What do
they show?

- Jon
 
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.
 
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/Pub0009/LPMArticle.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
 
Back
Top