You're not changing the axis. Del means change the values used on the X
axis. Select the chart, go to Source Data on the Chart menu, and click on
the Series tab. for each series, make sure that the X values points to the
correct range for that series (i.e., to {0%,50%,100%} for the series with 3
points, {0%,20%,40%,60%,80%,100%} for the series with 6 points), and that
the Y values points to the correct range. As Del points out, be sure to use
an XY chart, not a Line chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Martin" wrote in message
...
"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.