*** Interesting chart problem ****

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
NIThere 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|||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
"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
>
>