David,
This is exactly what I was looking for! I am very appreciative of you taking
the time to provide these references.
I am researching the possibility of using a pivot chart for scheduling
projects. Each project would have multiple activities. Projects would be
listed down the left side, dates would be listed across the top and each
activity of each project would appear as a colored bar on the chart. The
appearance of the chart would be like a stacked bar chart or Gannt Chart. Do
you have any comments?
Assuming this can be done, do you know if the individual bars would be
clickable to bring up a form with the details for that bar?