Samples of a variety of charts and techniques using Datagraph in one post…

[david blackwellParticipant]

Just a sampling of some local (Seattle) weather data using Datagraph 5.0 for all dataworks presented. Charts include time-series plots, Cleveland dot plots, Datagraph magnification, use of variables based on numbers from columns, explanatory text labels, etc.

I’m happy to share how I performed a graphic design task on any specific graphic if interested. Just post a reply.

https://www.litterrocks.com/weather-charts-and-graphics/2022/1/24/an-update-onthis-winters-rain-and-lack-of-sunshine

[pamelaModerator]

David – You’re site continues to amaze me – beautifully designed graphics that are clean and clear.

In particular, “Figure 4. Cumulative rain totals at Seattle-Tacoma International Airport for yearly periods beginning on October 1” is really impressive. It looks like you have a waterfall chart layered over the time series data.

There are several other design choices that I really like.  For example, the inset to the right of the graph and the axis labels for the months being a different color to offset them.

Could you explain how you are creating the x-axis for Figure 1 and 4?  My first instinct is that you would have to use an Extra Axis command but I don’t think that command works for dates.

Here’s hoping you get some sunshine soon!

[kdhakalParticipant]

I was going to ask the same thing as Pamela did and request either a screen cast or a Youtube tutorial. Then I thought Pamela probably has already started to work on the tutorial. Whoever decides to do it, would be worth watching! No pressure though…

Great work, David! Very inspring.

[jordanParticipant]

Yes Fig 4 is very nice. Great work! I would like to see more of the approach you used! Thanks!

 

jordan

 

 

[david blackwellParticipant]

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, 7 months ago by david blackwell.

[Author]

Posts