1^st scenario:

Is there a way to color code a stacked bar chart?  We need to have one horizontal bar with the colors listed below.  In other words, we need to color code a date range to a specific color based on the "Color" column.  I have it to the point of different colors for each date range in a single stacked bar, but cannot figure out how to link to a specific color.

 2^nd chart:

We are trying to create a chart that will show what medications a person is on and the time period they were on each.  Basically - the graph must look like the mock-up below.  The + signs are data points.  The  person could be on a medication for 2 months, then have a 5 month gap, then go back on the same medication again.  Is there a way to do this in Crystal?  The only chart we could find that was close was a Gantt chart, but that chart puts each item on one line. 

The data can be manipulated before crystal accesses it also - if that would make the chart more feasible.

Thank you!