How do I graph data from multiple years w/out x axis repeating mon

F

Frustrated

I'm trying to create a graph that shows simple Jan-Dec values on the x axis,
and plots individual years as the graph's series. I can create a graph that
shows and x axis stretching into infinity, but how do I confine the data
within one set of Jan-Dec values?
 
G

Guest

Sorry I don't have an explicit solution - don't do
graphing in Access. But think about extracting month
number (Month() function) from your data and plotting
against month number on the x-axis. Not sure how you'd
group/partition the data so that each year's worth is
confined to a group at plot time. Hopefully, someone else
will come to a more efficient rescue.

Just an idea.
 
Top