Charting Help
I need help with a best practice on charting information, using data entered monthly. I will try and explain below... We have lots of data we track by monthly numbers. I have setup a simple table ...
Forum Discussion
Just to share what I did on one of my monthly reporting tables, I have two fields that I use to graph by month.
Date field, sorted by month on the graph: ToDate([Month #]&"-28-"&[Year]) ... so I am setting the date as the 28th for them all.
Text field, sorted by equal values:
If([Month #]>9,
" -."&ToText([Month #]),
" - "&ToText([Month #])
)
... where I inserted the period as a way to push the months of Oct-Dec to the right of the other months. I use this to chart FY, which is April to April.
------------------------------
David Jung
------------------------------