Cumulative Graphs in Access 97

• • Reply

  19 years ago

  by bigjohndiddy

  John Maduka

  , United States

  Joined 19 years ago

  PROBLEM!
  I have an Access 97 (apologies, will upgrade!) database of Tenders, Sales People and Cumulative Accepted Sales along with a Cumulative Target. I’ve run a Query that produces the required sales figures. I need a line graph that plots Cumulative Annual sales against Cumulative Annual target.
  

  
  However, when I try to put this in a line graph in chart form with months on the X-axis (horizontal) and Cumulative on the Y-axis (vertical) – I get a flat line. If this is revered (months on Y-axis etc…) I get what looks like the required chart but I need the months to be on the X-axis. How do I do this without resorting to Excel's superior charting functions?!?!?!?
  

  
  Yours most perplexed!
  

  Report abuse