A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Can anyone help with this chart?



 
 
Thread Tools Display Modes
  #1  
Old September 23rd, 2009, 01:40 AM posted to microsoft.public.excel.charting
A little stuck[_2_]
external usenet poster
 
Posts: 19
Default 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.


Ads
  #2  
Old September 23rd, 2009, 02:01 PM posted to microsoft.public.excel.charting
Luke M
external usenet poster
 
Posts: 2,672
Default 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  
Old September 23rd, 2009, 06:13 PM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default 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  
Old September 24th, 2009, 12:53 AM posted to microsoft.public.excel.charting
A little stuck[_2_]
external usenet poster
 
Posts: 19
Default 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  
Old September 24th, 2009, 05:12 PM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default 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  
Old September 25th, 2009, 12:47 AM posted to microsoft.public.excel.charting
A little stuck[_2_]
external usenet poster
 
Posts: 19
Default 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.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:18 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.