Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / September 2006

Tip: Looking for answers? Try searching our database.

Difficult chart to compose?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Martin - 07 Sep 2006 18:17 GMT
I would like to make the following chart but don't know how to do this.
Data:
- for 5 persons I have values of a variable Y at different stages of
development.
- the number of stages of development that are distinguished differs between
the 5 persons (3, 4, 5 or 6 different stages).

The chart:
-The chart should show a line for each person with horizontally the stage of
development and vertically variable Y (so 5 lines).
-The line for the person for which 3 stages are distinguished should start
all the way to the left of the figure and stop all the way to the right of
the figure. So should the line for the person for which 6 stages are
distinguished. The only way, I can think of to do this, is create 30 stages
(a multitude of 3, 4, 5 as well as 6) and spread the values over these 30
stages so that all lines start all the way to the left and end all the way to
the right of the chart.
- The absolute numbers are not of interest. Variable Y is measured very
different for the different persons (and cannot be brought back to the same
unit of measurement). It is only the trend that is of concern. How can I take
this into account for the chart?

Thanks for any advice, in advance.
Del Cotter - 08 Sep 2006 19:38 GMT
>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.

Signature

Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
   which goes to a spam folder-- please send your email to del3 instead.

Martin - 10 Sep 2006 19:28 GMT
"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?

> >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
[quoted text clipped - 18 lines]
> 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.
Jon Peltier - 11 Sep 2006 02:51 GMT
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
_______

> "then go in and change the x-axes for all the persons to be a different
> x-axis"
[quoted text clipped - 24 lines]
>> 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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.