Monthly cycle charts show trend data in series of
monthly trend charts. This workbook includes VBA procedures to
automatically generate a monthly cycle chart.
Linear regression can be done with all the data or just
parts (segments) of the data to see if there are abrupt changes in the
relationship. The boundaries between the segments may be called
breakpoints. This post shows how to prepare a two segment regression
analysis of trend data. The downloadable workbook includes an
interactive method and a Solver based method to find breakpoint.
This workbook shows how to add colored shapes to an XY
chart to illustrate changes in categorical variables, like El Nino - La
Nina in the NYT's example.
