"then go in and change the x-axes for all the persons to be a different x-axis"
Thanks for your reply. Could you specify how you can to the above in Excel?

"Del Cotter" wrote:

On Thu, 7 Sep 2006, in microsoft.public.excel.charting,
Martin said:

I would like to make the following chart but don't know how to do this.
- for 5 persons I have values of a variable Y at different stages
- the number of stages of development that are distinguished differs between
the 5 persons (3, 4, 5 or 6 different stages).

Don't use a line chart, as getting the categories right will, as you
say, require a number of categories that has all of the different
possible number of stages as factors (30 has factors 3, 4, 5 and 6).

Instead use an XY chart. Construct the chart initially with the same
x-axis for your convenience, then go in and change the x-axes for all
the persons to be a different x-axis. You are now free to have each
person spread across their own range from left to right.

For 3 stages: 0%, 50%, 100%
For 4 stages: 0%, 33%, 66%, 100%
etc.

To be really fancy, you could make the x-axis a "named range" (actually
a misleading name for a much more powerful facility to create named
functions) to calculate the spread based on a cell reading "3" or "4" or
so on. But this is more fancy than you need just now.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.