1 Reply Latest reply on Feb 27, 2014 8:30 PM by davidanders

    Charting Event Dates

    kleink

      Title

      Charting Event Dates

      Post


           Hi,

           I'm trying to create a bar graph for an new events database to meet our "calendar" needs.  I want the chart to be broken done by how many events a month- so assigning the "Event ID" field to Y and "Date" field to X but it doesn't work.  It's culminating all the events instead of breaking it up. For example, there are 29 events total in the database so far- 5 in March, 12 in April, 4 in May, and 8 in June. The first bar in the graph goes up to 5 but then the next goes up to 17, the next to 21, etc. Any ideas on how to solve this?  I know there are calendar options out there to buy but a chart would be fine if we can get it right. Am I assigning the wrong fields to the axis? Is there some other solution to creating a calendar like bar graph?

           Thanks!