Pamela, et al.
Thank you for the kind words. Regarding the x-axis, I had a problem to overcome. I use a water-year construct for segregating the datasets. This created issues for me in both Microsoft Excel (where I post-process much of my data) and DataGraph. My water-year begins on the 1st day of the 10th month of a traditional year and ends on the 30th day of the 9th month. Sorting and segregating daily data using date fields was a challenge.
In essence, I assigned each row (daily) of data a new index called the Day of Wateryear (DWY). October 1 was DWY 01; September 30th of the following year was DWY 365 (0r 366 in leap years). DWY was the first data column imported into DataGraph. It was formatted as a number field.
I also created a new yearly index called a water-year in the form of yyyy-yz in my spreadsheet. In Datagraph, these water-years form the column names containing the annual dataset for each water-year respectively (e. 1948-49, 1949-50, etc.)
So the x-axis is plotted to the DWY field (a number). Specified tick marks were added on the last DWY of each month. Text labels were added as aides to viewers to help them find their way along the x-axis.
I crafted a quick web page with screen shots and more detail. As mentioned, it was quickly pulled together; there are likely errors on that page. More detail to follow on that web page in the coming days:
https://www.litterrocks.com/datawork-primer
Thanks again for the feedback. It’s very much appreciated.
-
This reply was modified 2 years, 8 months ago by david blackwell.