Chart

  • Thread starter Thread starter Paradigm
  • Start date Start date
P

Paradigm

I have a report produced using the chart wizard. It is intended to show a
running (accumulative) cost against month so the bottom axis has months but
since it spans a number of years, it also needs to show years and months.
How can I produce a chart that uses 2 variables on the bottom axis sorted
first by year and then by month?
Alec
 
There are several ways to skin the cat. Here's one.

In the report's record source (table or query) add a field that is a STRING
combination of the year and month, such as "200606". In your report, in the
Sorting and Grouping drop-down, use this combo field for the footer section.
You can format it any way you want for display purposes.

Hope this helps.

Sam
 
Back
Top