Oscillation (PDO) Trend Since 1900
RClimate script retrieves
on-line PDO data file and produces trend chart of monthly PDO trend
Consolidated Global Land
and Ocean Temperature Anomaly Series Since 1979
shows monthly temperature anomaly data for 5 major temperature L&O
anomaly series: GISS, NOAA, Hadley, RSS and UAH. First 3 use station
data, the last 2 use satellite based observations.
The CSV data file is updated monthly from source agency data files.
All source agency data is downloaded monthly so that any changes in
source data will be reflected in the consolidated file.
Focus on Global Warming
my site overhaul. Readers will notice that I am stressing the main
theme of my site, Global Warming. I have documented both my
Excel-R-Google Maps learning curves as well as my global warming
learning curve. My real drive has been to study global warming,
Excel - R - Google Maps have been my tools. I will be keeping my Excel,
R and Google Map tutorials so that visitors can continue to use them.
Script: Arctic Sea ice Extent Trends by Month
This R script allows users to retrieve monthly Arctic Sea Ice Extent
data file and generate a trend chart showing monthly traces for each
month. Users can source() the script to generate an up-to-date chart
without having to download either the data file or script.
RClimate Script: RSS Temperature Anomalies
This R script continues my effort to provide a family of R scripts that
allow users to access online climate agency without having to download
and store the source data or copy/paste scripts. Users can simply
source() the scripts to get a plot of the latest climate data.
RClimate Script: SST Anomalies
This R script retrieves NOAA's NCDC SST anomaly trend file, calculates
teh decadal means and generates a plot that highlights the latest
monthly reading. Users can run this script and reproduce chart on their
PC without having to download either the script or data file. Simply
source() the R script in an R session on your PC and you'll have the
chart ready to print on your PC.
I have started my long delayed site overhaul. I will be deleting
older Excel chart posts, data visualization and Google Mapping material
over the next few weeks.
R Climate Scripts
I have started a new page to present a series of R scripts that retrieve
on-line climate data from international climate agencies, process data
and generate trends charts. The R script files are set up so that users
can source() the file with 1 command and execute the R script from
ProcessTrends.com without having to download either the data or R
Decadal Trend Rates in Long Term Temperature Trend Chart
This post presents an R based chart of global GISS land and sea
temperature anomaly data for the 1880-2009 period with both the long
term trend and the individual decadal trends. Links to the source data
file and the R script are provided so that readers can reproduce/
improve on this analysis.
Chart Doctor Update
It’s been an interesting 24 hours in the chart
blog world. I am happy to announce that the
Chart Doctor name issue is completely resolved
on my part and I apologize for generating what
turned out to be an unnecessary controversy
because Akismet flagged my comment to Chandoo’s
post as spam.
Beware of New Chart Doctors:
I started this Chart Doctor page on 9/30/06. On 6/12/09, 21
months after I introduced this page,
Jon Peltier announce that they are adding a Chart Doctor feature to
This came as quit a surprise. I started the feature 21 months earlier
with full credit to Kaiser Fung as the source of my idea. Chandoo and
Jon got the same idea 21 months later, apparently without any
inspiration from Kaiser's JunkChart site or my Excel Chart Doctor page.
Interactive Regression with rpanel
- Hadley Wickham's Crantastic
site currently lists 1,531 R
packages. This post shows how I use one of these packages,
rpanel, to build an interactive regression tool. This R tool is
similar to the interactive
regression tool I built
Excel users often add check boxes, drop down lists to add
some interactive capabilities to worksheets. rpanel provides the same
type of capability in the R environment.
rpanel has been developed by Adrian Bowman, et al at the University
of Glasgow, Department of Statistics. They have several excellent
support documents and scripts at their site.
The R script and data files for my example are available for download.
R Lets You Insert Chart within Chart
In this post I give a quick tip on how to
embed one chart within another chart. This can be useful in situations
where you want to expand a part of your chart or show distinct ranges of
your data set.
Excel Bumps Chart of 209 Kentucky Derby
Don't Try This with Excel: In
this post I show 4 charts of the same data to demonstrate what Excel
chart users are missing by not having a more powerful charting tool.
This post, building on my previous discussion of using factors for
conditional formatting, shows the potential advantages of plotting
summary values and bounding area polygons . These analytical displays
are not readily available to even advanced Excel users.
Learn R Toolkit: I have
developed this toolkit to help Excel users quickly learn R so that you
can make those advanced charts that you really want to make. I use over
100 PowerPoint slides, 19 videos 40 R scripts, 12 data files and 3 Excel
workbooks to lead you up the R learning curve as quickly and comfortably
as possible. As an Excel user, I explain essential R concepts using
Excel examples and terminology so that you can learn R fundamentals
using your Excel knowledge. The videos demonstrate the R scripts and
then you use the same R scripts in a series of assignments. The R
scripts are fully commented and organized for reuse so that you can use
them as starter scripts for you real world projects. Finally, the
PowerPoint slides can be printed out to give you a valuable memory
jogger resource. This toolkit will save you many hours learning R.
Video Tutorial - Getting
Familiar with R: In this video, I show Excel users the R user
interface and walk through a simple R chart script. My goal is to help
Excel users see how R works so that you see it for yourself and consider
if it is worth your while to add R to your charting tool bag. I explain
the R windows, demonstrate an R charting session showing a step chart,
and explain the R script. My goal is to help advanced Excel users by
showing an alternative to Excel for multivariate charts. Excel VBA users
will see that R is a interactive, straight forward programming
environment that you may want to consider.
Temperature Anomaly Data Displays
- Is there a single "best" way to display temperature anomaly data? The
answer is obvious - NO! The best display depends on what we are trying
to show. Statistical charts compare one variable with one or more other
Since our display option affects how we interpret the data,
it is important to be clear on what we are comparing. In this post I
want to show 3 ways to display temperature anomaly data and the
implications that the display method has on our interpretation of the
data. I'll use a map, a trend chart and a dot plot.
Time Series Regression of Global Temperature, El Nino - La Nina and
Volcanic Events - In a
previous post, I showed how to make a 3 panel chart displaying RSS
temperature anomalies, El Nino- La Nina (NINO34 index) and volcanic
event (SATO Index) time series data. While time series charts can give
a visual impression of how time series are related, time series
regression provides much more information, including leading - lagging
relationships between the time series.
In this post, I analyze the RSS, NINO34 and SATO time series using a
simple trend line and a multiple regression model with lag periods for
the independent variables. The post demonstrates some of R 's
regression analysis and data lagging capabilities. Links to the R script
and data files are provided.
R Panel Chart Beats Excel Panel Chart:
In this post, I show how to make a 3 variable time series panel chart in
R. As an Excel panel chart pioneer, I can say that it would be very
difficult and messy to produce a comparable chart in Excel. The example
R chart uses panel chart, step chart, error bar and dynamic capabilities
not inherently available in Excel. No helper series are needed and the
chart can easily be regenerated each month as new data is available.
Interesting Data Tools: Tinkerplots
are many data analysis and charting tools that Excel users should check
out to see what is available in the world outside Excel. I’ll be posting
about interesting tools that I find and/or readers tell me about.
Here’s my first - Tinkerplots
R Works With Factors
In this post, I show how to create a factor variable from categorical
data and analyze the role of the factor and the decade using
conditional boxplots on time series data.
Showing Change Points in a Trend Chart with R
In this post, I describe change points and show how to add change points
to a trend chart with R. The chart shows El Nino - La Nina events
and long term global temperature anomaly trends that I originally
developed for the Excel Chart Doctor page. Readers can compare my R and
Excel - VBA solutions for the same chart to compare R and Excel VBA
Boxplots: R Does Them
In this post, I define a Tukey boxplot, review the history of boxplots
in Excel and walk through an R script for making a proper Tukey boxplot.
A link to the source data and R script files is provided.
Step Charts: R is
Easier than Excel In this post, I show how to make a step chart
with R. The chart also includes a lowess smoother and annotations. The
post walks through the R script and provides links to the R script and
data file for those Excel users who want to try R to see for themselves
what you can do with R.
Anatomy of an R
In this post, I examine an R script to show how to: 1) Read dynamic
data from a web site text file, 2) Determine number of data rows in
file; 3) Determine date of last measurement, 4) Create dynamic title;
5) Bank to 45, and 6) Create an XY Plot. Excel
users are encouraged to dust off their R program and try this script on
your own PC. Links to the source data and script are provided in this
R Lattice Plot Beats
Excel Stacked Column Chart -
Post 2 on my transition to R. In this post I look at an Excel stacked
column chart and show an R Lattice plot of the same data. The R Lattice
plot is much easier to interpret.
R Lattice Plot Beats
Excel Stacked Area Trend Chart -
This post starts a series on my transition to R that may be of interest
to those Excel chart users who struggle with Excel’s limited
multivariate chart capabilities. I will post videos and provide source
data files as well as R scripts on my ProcessTrends.com website
for those who want to try R for themselves.
Charts & Graphs Blog
- I have started a new blog to discuss who is doing what with charts
and graphs. Check it out! I'll be discussing principles of charting,
review chart tools - software and participate in discussions with data
visualization, charting bloggers.
Using R for Advanced Charts
- While trying to make advanced Excel based
charts, I often asked myself the question "...should I use R
for this chart instead of Excel". These charts were readily available in R.
I was reluctant to take on the R learning curve, I felt it was better to
use a tool that I knew and avoid the learning curve of a package like R.
I finally developed a set of VBA procedures to build a
full trellis chart. When I completed the Excel - VBA trellis
chart, I reconsidered R because I now know what it will take for me to develop the
trellis advanced charting that was already available in R.
Why reinvent trellis charts in Excel when they were
readily available in R? To answer this question, I needed to find
out how difficult the R learning curve was, I already knew what it takes
to develop these tools in Excel - VBA. The post video shows both
the Excel-VBA trellis chart tool and R trellis charting.
Showing Categorical Data on Trend Chart
- Another great New York
Times chart -
The New York Times graphics team (30 strong) is a great
source for ideas on good charting. I particularly like their
2008 trend chart of global temperature anomalies and El Nino - La
Nina episodes. This chart does not need any surgery, rather, it offers a challenge to Excel charters, how can we do that in Excel?
I've put together a workbook and video to show how we can add change
point rectangles to a XY trend chart.
Take a look....
Environmental Economics Article - Global Warming: Man versus Sun?
Environmental Economics website published this global warming article on
February 29, 2008.
The paper demonstrates effective data analysis and the use of charts to
demonstrate analysis points.
From a data visualization standpoint, the charts can be improved by
removing the Excel default background color and heavy grid lines.
VBA Code to Generate
Monthly Cycle Chart Automatically -Trend charts show the progression of your data over time. Some of
our time series data exhibit cyclical patterns, possibly
annual cycles related to seasons or weekly patterns related to work
schedules. This tutorial presents a workbook and VBA code that
automatically produces a
monthly cycle chart in Excel.
Escape from Spreadsheet Hell - Dynamic Ranges Can Help -
An Excel Chart User forum visitor recently posted this
request for help: "I am always charting 2 years of data. I have 2
spread sheets, one has multi charts and the other is all the data for
the charts. I'm tracking about 6 different data points in a line
chart. Each month the data sheet gets the previous months production
data. I'd like to have it automatically adjust the charts. Drop the
oldest month and add the newest month to the chart. That would save me
the time of manually updating the charts." Ravens Fan (Excel
Chart User Forum, 12/3/07)
I invited Ravens Fan
to send me his workbook. He sent it to me. Here's my Chart Doctor
diagnosis, solution to his problem and Raven's Fans report on how much
time he saves each month using dynamic range names.
Downloads - I've added a downloads
page to help keep track of the Excel workbook files that I have posted.
Segmented - Piecewise Regression - 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.
Replace Legend with Series Labels -
one of my favorite sites, has an interesting tool to help users select
the appropriate chart for their data. Juice's Line Chart example
includes a legend that tells the reader what color represent which data
Legends make it harder for the reader to interpret the chart
because he/she must move their eye back and forth between the series and
Let's replace the legend with data labels for each series to make it
easier to interpret. We don't want our message to get lost in the
The labels are added with a simple VBA procedure included in this
Interactive Regression This post shows how to
build an interactive regression worksheet that allows user to
adjust X value start and end points with scroll bars, automatically
compute regression values using Excel LINEST function,
assess goodness of fit, plot the results, display the regression line, r2
and significance of F test on the plot. Conditional formatting is used
to highlight F and t test significance. This workbook provides
equivalent regression results to the Analysis Toolpak Regression
procedure using standard Excel functions and formulas.
Plotting a Line From Runway Name - An Excel Chart User Forum
reader asked for help to draw runways based on the runway number
This is an interesting question, because the reader wants
to draw a line based on a name. The runway numbers drop the last digit
of the 3-digit heading, so 07 is actually 70 degrees..
We can use an XY chart to plot our lines. Since it only takes 2
points to define a line, we can use 0,0 to define one end and calculate
the X,Y coordinates for the 2nd point with simple trigonometry
functions. We can then plot our line with the start and end
points. This is the link
to the workbook.
Request for Interactive Chart - Multi Data Sheets - One of the
Excel Charting User Forum readers, asked if anyone had ideas on how to
create an interactive chart tool that lets the user interactively select
which data sheet and variable data column to use for the Y axis values
in a chart. The X axis is time, the reader also wanted the tool to let
the user select the start and end time.
The resulting downloadable
workbook provides several features:
1.Drop down menus for the data sheet
2. Drop down menu for variable
3. Scroll bar for minimum X axis value
4. Drop Down menu for X axis time increment
5. Macro to adjust X axis for min value & increment
6. Macro to prepare list of data sheets
Excel Regression Tools
- Excel provides a number of functions
that allow users to perform regression analysis of times
series/ trend data. This post shows 6 ways to
use Excel for regression analysis, from simple to advanced:
1. Add trend trend line with display of
regression and r2 to chart
2. Prepare manual
3. Use Excel Functions (INTERCEPT,
4. Use Excel Function - LINEST
Use Excel's Analysis Toolpak add-in
Combination of Excel Statistical Functions
Each approach is demonstrated using the same data set for each approach, annual
average temperatures, oC, in Vaexjoe, Sweden between 1918 and
2001. These annual values have been calculated from daily
observations archived by the European Climate Assessment and Dataset (ECAD)
site. The data and exhibits are all available in a
downloadable Excel workbook.
Beginning Day of Snowmelt - 3 Midwest Basins - Earlier snowmelt
is one of the potential results of global warming. This post reviews
work by P Neuman and the Open Mind blog on the beginning day of snowmelt
in 3 Midwest basins from 1910 to 2003. A downloadable workbook is
provided. The analysis includes trend charts, moving average charts,
CuSum control charts and change point analysis as well as regression
analysis to understand the trends in these 3 basins.
One Trend Chart Better than Two Pie Charts This Chart Doctor case
shows the share of world energy use by region for 1991 and 2006. The
original graphic uses two pie charts to show this data. From a
data visualization standpoint, we want the reader to be able to easily
compare energy share trends by region. The two pie charts require
the reader to scan back and forth between the pie charts to see the
changes for each region between 1991 and 2006. The
Chart Doctor chart version uses an XY trend chart so that the reader can
clearly see the energy share by region for both years and changes
between these years. The Chart Doctor
labels the1991 and 2006 point of each series to provide the actual data
Map Excel Data With Google
Google offers two mapping platforms: Google Earth and Google Maps. This
posts shows how to access web based KML files and display them in Google
Maps. The KML file is generated by the
MapExcelData.XLS workbook which incorporates VBA code by JuiceAnalytics and A
Simon into a reusable tool that lets you quickly generate KML files and
display your data in either Google Earth of Google Maps.
XY Chart Show
Trends Better than Clustered Column Chart This Chart Doctor case
shows trends in crime distribution by location for three categories in
Keene, NH. The original version used a clustered column chart. From a
data visualization standpoint, we want the reader to be able to easily
compare trends by the location category. The clustered columns make it
more difficult for the viewer to follow the trends of each location. The
Chart Doctor chart version uses an XY trend chart so that the reader can
clearly see the crime distribution trend by location. The Chart Doctor
labels the last point of each series rather than use a chart legend.
Finally, removing the data labels
makes the chart easier to interpret.
Map Excel Data With Google Earth
Google Earth is a powerful mapping tool that is readily available and
can be used to import and map user data. This workbook
demonstrates how to obtain the latitude and longitude for your Excel
data locations and how to export your Excel data to a Keyhole Markup
Language (KML) file for easy import into Google Earth. The attached
MapExcelData.XLS workbook incorporates VBA code by JuiceAnalytics and A
Simon into a reusable tool that lets you quickly generate KML files and
display your data in Google Earth.
Temperature Trend Analysis The
European Climate Assessment and Dataset
site maintains files of continuous daily mean temperature data for 100's
of European stations. The Stockholm, Sweden station has continuous daily
mean temperature data from 1756. This 250 years of daily Stockholm mean
temperature data were summarized into annual mean temperatures so
that I could assess the long term climate trends. The Stockholm
Temperature Trend Analyzer workbook includes ten (10) trend analysis
Tool to AnalyzeTemperature Trends: 5 Swiss Stations - Analysis
and interpretation of long term temperature data can be challenging.
This post shows how to make an interactive analysis tool to help in
interpretation of 100 years of daily temperature data from 5 Swiss
Multiple Trend Lines - Excel provides trend lines as part of the
chart package. How can show trend lines for 2 or more subsets of your
data? This example shows you how to add trend lines for up to 5 subsets
of your overall data set. The example shows 4 trend lines for user
selected periods of Northern Hemisphere temperature anomalies data set
for the period 1880 - 2006.
Global Warming Trends - This
page has been updated with a Law Dome ice core CO2 trend
chart; a consolidated horizontal panel trend chart of Vostok, Law Dome
and Mauna Loa Observatory CO2 data for the past 420,0000
years using two time scales in the same chart CO2 emission
trends chart since 1750, a horizontal panel chart of CO2
emissions per capita for selected countries in 2000 and a link to an
interesting YouTube Video on an innovative way to display a global
temperature trend chart.
Paleoclimate Trends - Continuous temperature records based on
thermometers only go back about 100 years. Paleoclimatology, the study
of past climate, uses several proxy data techniques to estimate climate
conditions over geologic time scales. The collaborative ice-core project
between Russia, the United States, and France at the Vostok station in
Antarctica extend the climate record back approximately 420,0000 years
in time. This page includes an Excel based vertical panel chart of the
CO2, methane and temperature trends for the past 420,000 years.
Temperature Changes Temperature changes by location, day of year
and time of day. How do we assess long term climate changes? To
facilitate assessments of long term climate trends, climatologists
compare the global mean temperature for a base period with the annual
mean for individual years. Differences between the annual mean and
baseline mean are called anomalies. NASA's Goddard Institute of
Space Studies (GISS) uses the
1951 - 1980 period for their baseline period. They use the difference
between the global temperature mean for a year and the baseline mean to
determine the global temperature anomaly for the year.
presents an Excel based chart, using GISS data available,
that shows the annual global temperature anomalies for the period 1880 -
Custom Chart Axis Tutorial
XY Charts let us accurately place
data markers exactly where we want in a 2
dimensional grid. Excel lets us format our chart axes by adjusting the scale range,
interval and axis number formats.
There are times when we need to use more than Excel's standard XY Chart axis
formatting to have the X or Y axis look the way we want. We can use custom
axes to make those critical charts that Microsoft did not include with Excel:
dot plots, bumps charts, panel charts and others.
Dot Plot with 2 Level Y Axis Labels This Chart Doctor case shows
a Data360.org column chart of automobile CO2 emissions by vehicle. The
vehicle labels are aligned vertically, making reading difficult. The
vehicle name combines manufacturer, vehicle type and model into a single
name, limiting group comparisons. From a data visualization standpoint,
we want the reader to be able to easily compare emissions by vehicle
type, not have to scan across. The Excel chart version uses a dot plot
with 2 level Y axis labels so that the reader can compare by vehicle
Stacked Bar Charts Not
Clear - This Chart Doctor case shows a stacked bar chart of
world oil consumption growth and an alternative trend chart. Stacked bar
charts are a poor chart type in many cases because they require the
reader to do quick arithmetic calculations to assess the lengths of the
bar segments to assess the changes. From a data visualization
standpoint, we want the reader to see the trend, not have to calculate
it. The Excel workbook includes the data and shows how to add custom X
and Y axes.
Banking to 45o to Enhance Visualization
Cleveland has shown that we can enhance XY chart visualization by
careful selection of the data rectangle (area inside axes) height to
width (h/w) aspect ratio. Banking to 45o is a technique that
adjusts the aspect ratio so that the line segment orientations average
This page presents an Excel workbook that implements Cleveland's aspect
ratio and banking to 45o
Advanced Charting Techniques -
I use a number of techniques and tips over and over to make my enhanced
Excel charts. I have grouped these techniques into 5 learning steps to
provide my recommended road-map for learning enhanced Excel charting.
These techniques will help you to add lines, add text, make dummy axis
series, label points, make dynamic/interactive charts and dashboards.
Chart Doctor - Operating Room
Schedule - I received an e-mail request from a real doctor who wanted help
developing a chart to show the schedule for an operating room. The
doctor sent along his hand sketch. He wanted to be able to
show time of operation from 6:00 AM till 8:00 PM .
I developed a
floating bar chart using a simple XY chart with error bars.
Level Changes - The United Nations Environment Programme reports
that mean sea levels have risen 10 to 25 cm over the past 100 years.
This sea level increase is caused by thermal expansion of warmer water,
retreat of glaciers and ice caps and a net positive contribution from
the huge ice sheets of Greenland and Antarctica.
The linked workbook provides sea level trend data for 11
locations along the North Atlantic. Users can select the location from a
pull down list and generate a trend chart for that location.
Trends - CO2 has been increasing as a result of
fossil fuels. This page presents an Excel based CO2
trend chart and monthly cycle chart of monthly CO2 data from Mauna
Loa Observatory, Hawaii.
Global Warming Trends - Global
warming is a very serious, complex and controversial subject. This page
presents Excel charts of global warming related data. Each post
includes a link to the data source and where appropriate, sites that
provide the scientific/theoretical underpinnings to the demonstrated
Trends - As an environmental engineer, I have been concerned about the
environment for many years. This new page, combing my data
analysis and environmental interests, presents Excel charts that
show global environmental trends.
I have made each
chart in Excel from on-line data sources. The workbooks are available on
|Chart Doctor -
This new page presents examples of published charts that have been
improved/ enhanced with the use of Cleveland/ Tufte data
visualization principles and Excel charting techniques presented in
I got the idea for this page from Kaiser Fung's
site, one of my favorite data visualization sites. Kaiser clips
interesting charts/graphs from publications and critiques them from
a data visualization standpoint, often presenting one or more
alternative ways to display the data more effectively.
Borrowing Junk_charts.com's approach, from time to time, I will
present a published chart, diagnose it's data visualization health
and produce an Excel version. Readers are
encouraged to perform their own surgery on
my chart. I'll be happy to post any effective chart surgery results that readers
Visualization and Excel - In deciding what type of chart/ graph
to use, it is helpful to understand your chart viewers graphical feature
interpretation skills. W. Cleveland (1984) conducted experiments to
measure these abilities. This page uses Cleveland's results to assess
standard Excel charts effectiveness.
W. Cleveland advocates the use of trellis like displays, Tufte advocates
the use of small multiple charts. Advanced statistical and graphical
packages allow users to prepare trellis, small multiple charts.
While not a default chart type, Excel users can develop trellis
display/small-multiples like charts in Excel by using standard
|Bumps Chart -
These charts are very useful in showing before - after changes in rank
or value. Originally developed to track crew race outcomes in England,
they can be applied to many situations where excel users rely on stacked
or clustered bar charts. This page shows several Excel bumps charts.
Plot - While Excel provides both pie and doughnut charts, there
are a number of data visualization problems associated with these charts
so that users should rarely use them. Dot plots provide Excel chart users
an effective alternative to pie/ doughnut charts. Panel dot plots
can be used to show changes over time with small multiple -
trellis like displays. This page and download shows an Excel panel
dot plot using standard Excel charting, data transformations and
dummy axis techniques that are all explained in this site.
Horizontal Panel Chart - Alternative to Stacked Column Chart -
Stacked charts have data visualization limitations such that users
should look for alternatives before using them. Horizontal panel charts
are a good alternative. this example shows how to use dummy axes to
construct a panel chart similar to S-plus trellis like charts.
horizontal panel chart of UK Hospital Bed trends for the period FY 1988
to 2005. The original stacked column chart is shown to provide a
comparison of the effectiveness of both chart types.
XY Trend Chart in Excel - Data visualization researchers
have similar advice when plotting multivariate data:
Cleveland and Robbins
recommend "Trellis Displays". Advanced statistical and graphical
analysis systems like R and
include Trellis display capabilities. Trellis like chart displays increase your
ability to visualize your data. This tutorial and example workbook show you
how to build a small multiples trend chart to get a trellis like display affect
Cycle Chart in Excel Trellis like chart displays increase your
ability to visualize your. This tutorial and example workbook show you
how to build a monthly cycle chart to get a trellis like display affect
|No Chart Junk
New page dedicated to data visualization information for the rest of
us. Includes reviews on data visualization books, links to data
visualization sites, and links to articles on pros and cons of Excel for
statistical analysis and charting.
Axis Series We can use a dummy date axis series to label our
months and/or years the way we want, and improve on the default data
workbook also shows how to build a Step chart in Excel.
Stacked Trend Charts - Data Transformation Technique - This tutorial
is one of two on this Site that show you how to build a series of XY trend charts
that are aligned
vertically so that you can compare trends between several parameters at the same
time. This page shows the data transformation and dummy Y axis series technique
and is based on the example found in
|Learn How To Add Events to Your Trend Charts -
Trend charts show values for a data series over time. There are usually
outside factors that affect our trend data series. The addition of these
events can significantly enhance the educational value of our trend
charts. This tutorial and workbook show you how to add event information
to your trend chart to increases its explanatory value.
Dynamic Excel Trend Chart video - Excel has powerful
interactive charting capabilities that many Users do not use because
they are unaware of them. This
demonstrate how a combination of dynamic range names, controls and VBA
can be used to transform static data and charts to an interactive tool
that can help users analyze and understand their trend data.
|Dot Plots -
Alternative to Pie Charts - Many data visualization writers
recommend against use of Pie charts. This workbook compares
a Dot plot and Pie Chart for the same data. It shows you how to create
axis label (dummy) series for Y axis and log scale X axis.
Interactive Trend Chart - Checkboxes - This workbook shows you
how to use dynamic range names and checkboxes to let user select which
data series should be plotted.
|Excel Box Plots -
2 Working Examples - Excel does not provide a pre-made Box
Plot option. With a few steps, however, Users can make there own Box
Links -This workbook includes links to 150 Excel chart articles
and downloads. Use the built in query macro to find links to articles on
Dashboard Sheet Layout Video - This 5 minute video shows you how
to layout your worksheet. The accompanying
workbook includes the
VBA procedure demonstrated in the Video,
- This workbook includes 7 VBA procedures to handle a wide
range of data scrubbing situations often found in working with process
|Using Excel's Camera
Tool with Dashboards
Year Trend Chart
|Excel Process Data How
|Process Data Tool Kit Video
- 6 minute Introduction to this Excel -VBA treatment plant data
|Trend Charts and
|Size - Align
Moving Average Chart
Vertical Line to XY Chart
Min & Max Values on XY Chart
|Adjusting Cell Size with VBA
|Making a Chart in a Cell with VBA
|Build Control Chart
Horizontal Line to XY Chart
Stacked XY Trend Charts
Control X Axis Min - Max Values