Can anyone help with this chart?

[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.

 

[Luke M]

Check out Jon Peltier's article on creating a vertical category axis:

http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html

 

[Jon Peltier]

Are the Y "values" some kind of rating? Where do the points go? What do
they show?

- Jon

 

[A little stuck]

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]

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

 

[A little stuck]

Thank you very much for your help, problem solved