Reply
Hello,
The type of chart that I need to create is a bar chart using data much like the sample I sent previously. I have not been able to create a chart using this data. What I need to do is chart using data that looks like:
Task: ABC;123;XZY
Projected Date Funding Runs out: 3/31/2010;4/25/2010;12/31/2010
The Tasks would run across the bottom of the chart.
The Dates would be on the left-hand side.
I want the bar to stop for each task at the Projected Date.
I can't figure out how to chart this since I have to use a number field for the left-hand side or so it seems. It might not be possible. I can do this in Excel but not in Access or Cognos (another reporting tool we have).
What I meant when I said that I could create other charts is that I can successfully create charts using your program just not using data as my example above to create a 'Projected' Chart using a Date field along with a Text field where I don't need to sum the data.
Thanks for your persistance!