Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
horrifyingly difficult excel chart / gantt question... | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) |