3 Replies Latest reply: Nov 30, 2011 5:14 AM by Pierre Philippon RSS

    Two problems with my chart: weekends and continuous data

      Hello
      I am trying to plot a standard line chart, X=Dates and Y=Sum(Percentages of product)
      In my access table I have all the dates I would like to show on my chart as the Sum(Percentage of product)=100% every day.
      So when I show all data, I have all dates and 100% for each date.
      Now when I select one product, the Sum(Percentage of product) might have a data on that particular date or be empty.
      My problem is that:
      - if I set the X=Dates as continuous, I have all the dates (including weekends which would be nice if I could get rid of) and the Dates for which the Sum(Percentage of product) is empty will have no data and the line will continue from the last available point to the next, which is misleading.
      - if I do not set the dates as continuous, the empty data will just not show. I would like them to be zero instead. Empty=zero to me.
      I have attached the 2 charts which are not what I want. I would like to have all the dates on my X axes excluding weekend) and show 0 when data is missing.I hope that makes sense.
      Many thanks in advance.
      22/02/20115.9%
      23/02/20115.9%
      24/02/20116.0%
      25/02/20117.0%
      28/02/20116.8%
      01/03/20115.9%
      02/03/20114.5%
      03/03/20112.5%
      04/03/20110.0%
      07/03/20110.0%
      08/03/20110.0%
      09/03/20110.0%
      10/03/20110.0%
      11/03/20110.0%
      21/09/20110.0%
      05/10/20110.4%
      06/10/20112.7%
      07/10/20113.2%
      10/10/20113.5%
      11/10/20113.5%
      12/10/20113.6%
      13/10/20113.4%
      14/10/20113.6%
      17/10/20113.6%
      18/10/20114.5%
      19/10/20114.4%
      20/10/20114.4%
      As you can see, the dates are only Working days, and there are period where there is no data. My problem is that I would like to do a continuous chart, by that I mean having all dates