LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 336
Default Difficult chart to compose?

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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
horrifyingly difficult excel chart / gantt question... [email protected] Charts and Charting in Excel 1 February 2nd 06 06:08 PM
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
Urgent Chart Assistance Brent E Charts and Charting in Excel 1 May 10th 05 09:09 AM
Urgent Chart Questions Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM
Urgent Chart Assistance Requested Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM


All times are GMT +1. The time now is 06:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"