Sorting

[hke]

I have a to column of numbers like this

1 value1
2 value2
3 value3
4 value4
1 value5
2 value 6
3 value 7
4 value 8
1 value 9

.. and so on. I want to chart the values in a common 2d time - valu
way, which in this case not is straightforward because the duration o
the values are determined by which category they belong to. Now al
values have a duration of 1, which is not the case. The leftmos
numbers indicates the category that the corresponding value belong t
(1, 2, 3 or 4). The different categories have properties like this

1 20%
2 40%
3 30%
4 60%

, meaning that the duration of all values in category 1 should b
weight distributed by 20 % relative to the other categories, and so on


The values are not to be changed, only their duration in a time-valu
chart. I guess one way to to this is to have the values appear lik
this

value 1
value 1
value 2
value 2
value 2
value 2
value 3
value 3
value 3

 

[Guest]

interesting sounding problem...
Time axis description? Values are sequential in time?
Overlapping? Simultaneous?

Thinking you might need a new column of time duration
values with these new values and original values plotted
on a x-y scatter chart. But maybe you want variable width
columns? Something else?
If you get no other responses that work for you, post
back. Would like to work through this one, but need more
discussion/info.
My time now is 8:40 CDT - looking for your and others'
responses.

Regards, hcj