This question is locked. New answers and comments are not allowed.
Hi,
I want to produce a chart like in the attached image.
I can do it at the moment using 3 different series of barcharts.
But this gives me several hundred bar - not the best performance of course (also memory wasting).
My data is a series of "states" - one for every minute where a state can either be 1, 2 or 3.
So the original data is something like
17:00 1
17:01 1
....
17:35 1
17:36 2
17:37 2
...
18:10 2
18:11 3
...
22:08 2
22:09 1
22:10 1 (last datapoint)
I already compress this data for storage like this:
17:00 1
17:36 2
18:11 3
22:08 2
22:09 1
22:10 1 (last datapoint)
This means - I start with the first - store the next when a change happens, and so forth.
Something like "remember the changes" - with the exception that I always store the last point no matter what the last but one was.
I can easily achieve a chart like in the attachment - with the original data.
I want to build it from the compressed ones.
I I could do it with a rectangle line - but I need different colored fill - and no line at all - just bars.
Can this be done?
Manfred
I want to produce a chart like in the attached image.
I can do it at the moment using 3 different series of barcharts.
But this gives me several hundred bar - not the best performance of course (also memory wasting).
My data is a series of "states" - one for every minute where a state can either be 1, 2 or 3.
So the original data is something like
17:00 1
17:01 1
....
17:35 1
17:36 2
17:37 2
...
18:10 2
18:11 3
...
22:08 2
22:09 1
22:10 1 (last datapoint)
I already compress this data for storage like this:
17:00 1
17:36 2
18:11 3
22:08 2
22:09 1
22:10 1 (last datapoint)
This means - I start with the first - store the next when a change happens, and so forth.
Something like "remember the changes" - with the exception that I always store the last point no matter what the last but one was.
I can easily achieve a chart like in the attachment - with the original data.
I want to build it from the compressed ones.
I I could do it with a rectangle line - but I need different colored fill - and no line at all - just bars.
Can this be done?
Manfred