Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Y-axis value in a chart

Status
Not open for further replies.

watercooler

Programmer
May 7, 2004
13
0
0
CA
I have a simple query that I need to graph. The query looks like this:

relMonth CountOfIssues RunTot2
Aug '03 12 12
Oct '03 1 13
Nov '03 7 19
Dec '03 2 21
Jan '04 2 23
Feb '04 11 34
Mar '04 5 39
Apr '04 31 70
May '04 3 73
Jun '04 12 85
Jul '04 130 215
Aug '04 1 216

RunTot2 uses DSum to collect a running sum of new issues. Anyway, all I want to do is generate a bar chart with RunTot2 as the y-axis and relMonth as the x-axis. Access keeps trying to do a count of RunTot2 and it won't let me choose it to take no action when I double click on the button in the Chart Wizard. This is dead simple to do in Excel so I am assuming that there is a very simple solution in Access...I just can't see it.

Any help is much appreciated,
Rob
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top