Thanks Robert for the solution. I got through the problem, by creating a
table, and then having 24 columns ( for each hour) in the table, and did some
math, and changed the background color of the cells in the table. With some
math I figured out whihc is the first cell in the table that needs to be
colored, and the last cell, and accordingly acheived a gantt chart look.
However it would be nice if RS includes a gantt chart option in the chart
options. (kind of like the MS project charts).
Thanks
[quoted text, click to view] "Robert Bruckner [MSFT]" wrote:
> There is no good way to achieve this kind of visualization - but here is an
> idea: use a scatter line chart and create the dataset so that you have the
> start time and the end time for one projector in different rows. Anyway, it
> won't be easy to achieve this.
>
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
> "Nagini Indugula" <NaginiIndugula@discussions.microsoft.com> wrote in
> message news:DFF5D09D-28B7-4DAB-B86C-5A2EDE25D978@microsoft.com...
> > Hi:
> >
> > Lets say for eg: you have LCD projectors that you can borrow at various
> > times in a day. I need to create a chart that shows the 24 hours (like
> > 12AM,
> > 1AM, 2Am, 3Am...11PM, 12PM), on the X axis, and the LCD resource name on
> > the
> > Y axis, and if it was booked between 2AM and 4AM, have a colored bar
> > between
> > 2Am and 4Am, and rest blank, and so on for all the resources.
> >
> > What are my options to do something like this. Cant seem to find any way
> > to
> > do this.
> >
> > Thanks
> > NI
>
>
