Downloads
|
File |
Description |
Image |
Bank to 45o |
|
|
Blood_pressure_trend.zip
|
|
|
Box_plot_trend.zip
|
|
|
Chart_DOY_trend_comparison.zip
|
|
|
Chart_hyperinks.zip
|
|
|
Chart_Interactive_dynamic_xls.zip
|
|
|
Chart_min_max.zip
|
|
|
Chart_missing_data.zip
|
|
|
Chart_monthly_cycle_tmpl.zip
|
|
|
Chart_mov_avg.zip
|
|
|
Chart_trend_with_events.zip
|
|
|
Charts_dot_plot.zip
|
|
|
Charts_parallel_XY_trend.zip
|
|
|
Chrt_doc_runway_chart.zip
|
|
|
Chrt_doc_runway_chart_rev_2.zip
|
|
|
Chrt_doc_sel_sh.zip
|
|
|
Chrt_in_Cell.zip
|
|
|
Chrt_size_align.zip
|
|
|
Chrt_XY_trend_animation.zip
|
|
|
CO2.zip
|
|
|
CO2_consol_ML_Vol_Law.zip
|
|
|
Dashboard_sheet_layout.zip
|
|
|
DJIA Trend Chart Format
|
|
|
Dyn_chart_plot_last_X_values.zip
|
|
|
Energy_Stat_Charts_1.zip
|
|
|
Eur_temp_stations.zip
|
|
|
Excel_Regression_tools.zip
|
|
|
Exhibit_Intro.zip
|
Video - Introduction to MIT's Exhibit 2.0. Shows community crime map using Google Maps and interactive query ability. |
|
Fecal_imperv.zip
|
|
|
GISS_global_temp_anomalies.zip
|
|
|
Hor_panel_chart.zip
|
|
|
Interactive_chart_check_box.zip
|
|
|
Interactive_chart_check_box_xls.zip
|
|
|
Inter_dyn_excel_charts_wmv.zip
|
|
|
Interactive_Regression.zip
|
|
|
Juice_line_chart.zip
|
|
|
MapExcelData.zip
|
|
|
Mo_cycle_chart_vba.zip
|
Monthly cycle charts show trend data in series of monthly trend charts. This workbook includes VBA procedures to automatically generate a monthly cycle chart. |
|
Multi_chart.zip
|
|
|
N_Hem_GISS_Temp_anomalies.zip
|
|
|
Op_room_schedule.xls
|
|
|
Open_mind_snowmelt.zip
|
|
|
Open_mind_swiss_temps_1.zip
|
|
|
Open_mind_swiss_temps_cpa.zip
|
|
|
Open_mind_temps.zip
|
|
|
Panel_dot_plot.zip
|
|
|
PDTK_overview_3_21_06.zip
|
|
|
Process_Dashboard.zip
|
|
|
Screen_dashboard.zip
|
|
|
Sea_Level_N_Atlantic.zip
|
|
|
Seg_piecewise_regr.zip
|
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. |
|
Stacked_Trend_Chart_Trans_data.zip
|
|
|
Stacked_trend_chrt.zip
|
|
|
Trend_w_Change_pt_enso.zip
|
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. |
|
Temp_trend_Stockholm.zip
|
|
|
Trellis Chart with Excel and R
|
|
|
Trend_control_chart_basics.zip
|
|
|
Vostok_temp_420_k_yrs.zip
|
|
|
XY_step_chart_formattted_dates.zip
|
|
|