I want to genereate a report to show plant status (in time series) within the last two shifts (12 hours a shift). here is the example data i want to report using 100% stacked Bar Chart seqid timestamp status shift time 1 2011-09-09 18:00:00.000 Running 1 7 2 2011-09-10 01:00:00.000 Water 1 1.5 3 2011-09-10 02:30:00.000 CIP 1 0.25 4 2011-09-10 02:45:00.000 DownTime 1 1 5 2011-09-10 03:45:00.000 Running 1 2.25 6 2011-09-10 06:00:00.000 Water 2 1 7 2011-09-10 07:00:00.000 CIP 2 0.5 8 2011-09-10 07:30:00.000 DownTime 2 1 9 2011-09-10 08:30:00.000 Running 2 3 10 2011-09-10 11:30:00.000 CIP 2 2 11 2011-09-10 13:30:00.000 Running 2 4.5 this is what i've done: use [Status] [SeqId] as Series Groups Results: However, this is not exactly what i want. - I would like to have the same plant status to be the same color: for example: Status "Running" for shift 1 and 2 should be the same color. i don't know how to group them properly to be able to do that. - the x-axis range should be from 0 to 12(hr), each shift is 12 hours. Your help is deeply appreciated !!!! Regards Simon Wang