Seven essential Excel data visualization tips

Introduction

Inspiration for this talk

Another inspiration for this talk

One more inspiration

Art by Allison Horst

Seven essential Excel data visualization tips

Image bar chart

Seven essential Excel data visualization tips

Image bar chart
Geographical heat map

Seven essential Excel data visualization tips

Image bar chart
Geographical heat map
Color scales

Seven essential Excel data visualization tips

Image bar chart
Geographical heat map
Color scales
Sparklines

Seven essential Excel data visualization tips

Image bar chart
Geographical heat map
Color scales
Sparklines
REPT charts

Seven essential Excel data visualization tips

Image bar chart
Geographical heat map
Color scales
Sparklines
REPT charts
Data bars

Seven essential Excel data visualization tips

Image bar chart
Geographical heat map
Color scales
Sparklines
REPT charts
Data bars
Icon sets

Tools we’re using today

ggplot2

ggplot2 implements the grammar of graphics, a coherent system for describing and building graphs. With ggplot2, you can do more faster by learning one system and applying it in many places. - R4DS

A rapid introduction to ggplot2

gg stands for grammar of graphics.

Set up the plot with ggplot()
Add your data
Specify variables with aes()
Choose chart type with geom()
Add new elements as layers with a plus sign (+) between layers
Style with themes

ggplot(data = df_name, 
      aes(x = x_var_name, 
          y = y_var_name)) +
  geom_type() +
  ...

A rapid introduction to ggplot2

Set up plot

library(ggplot2)

ggplot(data = ci_np,
       aes(x = year,
           y = visitors)) +
  geom_line()

A rapid introduction to ggplot2

Add customization

library(ggplot2)

ggplot(data = ci_np, 
       aes(x = year, 
           y = visitors)) +
  geom_line(
    color = "#028BA8",
    linetype = "dashed"
  )

A rapid introduction to ggplot2

library(ggplot2)

ggplot(data = ci_np, 
       aes(x = year, 
           y = visitors)) +
  geom_line(
    color = "#028BA8",
    linetype = "dashed"
  ) +
  theme_minimal()

A rapid introduction to ggplot2

library(ggplot2)

ggplot(data = ci_np, 
       aes(x = year, 
           y = visitors)) +
  geom_line(
    color = "#028BA8",
    linetype = "dashed"
  ) +
  theme_minimal() +
  labs(
    x = "Year",
    y = "Annual park visitors",
    title = "Channel Islands NP Visitation",
    subtitle = "(1963 - 2016)"
  )

A rapid introduction to ggplot2

The ggplot2 package works best with “tidy data”.

“Wide” format:

park_name `2012`   `2013`   `2014`
<chr>     <int>    <int>    <int>
CI        249594   212029   342161

“Long”/“tidy” format:

park_name visitors   year
<chr>     <int>      <int>
CI        249594     2012
CI        212029     2013
CI        342161     2014

gt

With the gt package, anyone can make wonderful-looking tables using the R programming language. The gt philosophy: we can construct a wide variety of useful tables with a cohesive set of table parts. These include the table header, the stub, the column labels and spanner column labels, the table body, and the table footer.

gt

gt stands for grammar of tables.

A rapid introduction to gt

library(gt)

gt(ci_np)

region	state	code	park_name	type	visitors	year
PW	CA	CHIS	Channel Islands National Park	National Park	212029	2013
PW	CA	CHIS	Channel Islands National Park	National Park	342161	2014
PW	CA	CHIS	Channel Islands National Park	National Park	324816	2015
PW	CA	CHIS	Channel Islands National Park	National Park	364807	2016

A rapid introduction to gt

library(gt)

gt(ci_np) |>
  tab_header(title = "Channel Islands NP Visitation",
             subtitle = "Annual park visitors")

region	state	code	park_name	type	visitors	year
Channel Islands NP Visitation
Annual park visitors
PW	CA	CHIS	Channel Islands National Park	National Park	212029	2013
PW	CA	CHIS	Channel Islands National Park	National Park	342161	2014
PW	CA	CHIS	Channel Islands National Park	National Park	324816	2015
PW	CA	CHIS	Channel Islands National Park	National Park	364807	2016

A rapid introduction to gt

library(gt)

gt(ci_np) |>
  tab_header(title = "Channel Islands NP Visitation",
             subtitle = "Annual park visitors") |>
  fmt_number(columns = visitors,
             decimals = 0,
             use_seps = TRUE)

region	state	code	park_name	type	visitors	year
Channel Islands NP Visitation
Annual park visitors
PW	CA	CHIS	Channel Islands National Park	National Park	212,029	2013
PW	CA	CHIS	Channel Islands National Park	National Park	342,161	2014
PW	CA	CHIS	Channel Islands National Park	National Park	324,816	2015
PW	CA	CHIS	Channel Islands National Park	National Park	364,807	2016

A rapid introduction to gt

library(gt)

gt(ci_np) |>
  tab_header(
    title = "Channel Islands NP Visitation",
    subtitle = "Annual park visitors") |> 
  fmt_number(columns = visitors,
             decimals = 0,
             use_seps = TRUE) |> 
  data_color(visitors)

region	state	code	park_name	type	visitors	year
Channel Islands NP Visitation
Annual park visitors
PW	CA	CHIS	Channel Islands National Park	National Park	212,029	2013
PW	CA	CHIS	Channel Islands National Park	National Park	342,161	2014
PW	CA	CHIS	Channel Islands National Park	National Park	324,816	2015
PW	CA	CHIS	Channel Islands National Park	National Park	364,807	2016

Seven essential Excel data visualization tips (in R!)

Image bar chart

Seven essential Excel data visualization tips

Image bar chart
Geographical heat map
Color scales
Sparklines
REPT Charts
Data bars
Icon sets

Image bar chart

A bar plot

head(mtcars)

                   mpg cyl disp  hp drat    wt  qsec vs am gear carb
Mazda RX4         21.0   6  160 110 3.90 2.620 16.46  0  1    4    4
Mazda RX4 Wag     21.0   6  160 110 3.90 2.875 17.02  0  1    4    4
Datsun 710        22.8   4  108  93 3.85 2.320 18.61  1  1    4    1
Hornet 4 Drive    21.4   6  258 110 3.08 3.215 19.44  1  0    3    1
Hornet Sportabout 18.7   8  360 175 3.15 3.440 17.02  0  0    3    2
Valiant           18.1   6  225 105 2.76 3.460 20.22  1  0    3    1

A bar plot

library(ggplot2)

ggplot(data = mtcars) +
  geom_bar(aes(x = cyl))

A bar plot

library(ggplot2)

ggplot(data = mtcars) +
  geom_bar(aes(x = cyl,
               fill = as.factor(cyl))) +
  theme(legend.position = "none") + 
  labs(title = "ggplot fill")

A bar plot

library(ggplot2)

ggplot(data = mtcars) +
  geom_bar(aes(x = cyl,
               fill = as.factor(cyl)),
           color = "black")

A bar plot

library(ggplot2)

ggplot(data = mtcars) +
  geom_bar(aes(x = cyl,
               fill = as.factor(cyl)),
           color = "black") +
  theme_minimal() + 
  labs(title = "ggplot fill")

Hello, ggpattern!

ggpattern provides custom ggplot2 geoms which support filled areas with geometric and image-based patterns.

A bar plot + ggpattern example

library(ggplot2)
library(ggpattern)

ggplot(data = mtcars) +
  geom_bar_pattern(
    aes(x = cyl,
        pattern_fill = as.factor(cyl)), 
    pattern = "stripe",
    fill    = "white",
    color  = "black") +
  theme(legend.position = "none") + 
  labs(title = "ggpattern pattern_fill")

A bar plot + ggpattern example

A cuter bar plot + ggpattern example

library(ggplot2)
library(ggpattern)

ggplot(data = mtcars) +
  geom_bar_pattern(
    aes(x = cyl,
        pattern_fill = as.factor(cyl)), 
    pattern = "placeholder",
    pattern_type = "kitten",
    fill = "white",
    color = "black") +
  labs(title = "ggpattern placeholder image") + 
  theme(legend.position = 'none')

A cuter bar plot + ggpattern example

An image bar chart with ggpattern

library(ggplot2)
library(ggpattern)

logo1 <- "~/R/excel-data-viz-tips-in-r/images/excel.png"
logo2 <- "~/R/excel-data-viz-tips-in-r/images/sheets.png"
logo3 <- "~/R/excel-data-viz-tips-in-r/images/gt-tab.png"

ggplot(data = mtcars) +
  geom_bar_pattern(
    aes(x = cyl,
        pattern_filename = as.factor(cyl)),
    alpha = 0,
    pattern = "image",
    pattern_type = "squish"
  ) +
  scale_pattern_filename_manual(
    values = c(`4` = logo1, `6` = logo2, `8` = logo3)) +
  theme_minimal() +
  theme(legend.position = "none") +
  labs(title = "ggpattern custom image")

An image bar chart with ggpattern

Geographical heat map

Seven essential Excel data visualization tips

Image bar chart
Geographical heat map
Color scales
Sparklines
REPT Charts
Data bars
Icon sets

Geographical heat map

Also known as “choropleth” maps.

A world map

library(dplyr)
library(ggplot2)
library(maps)
  
# Access world map data using the `map_data()` function
world_map <- map_data("world")
head(world_map)

       long      lat group order region subregion
1 -69.89912 12.45200     1     1  Aruba      <NA>
2 -69.89571 12.42300     1     2  Aruba      <NA>
3 -69.94219 12.43853     1     3  Aruba      <NA>
4 -70.00415 12.50049     1     4  Aruba      <NA>
5 -70.06612 12.54697     1     5  Aruba      <NA>
6 -70.05088 12.59707     1     6  Aruba      <NA>

A world map

ggplot(data = world_map) +
  geom_map(map = world_map,
           aes(x = long,
               y = lat,
               map_id = region))

A little more complex world map

ggplot(data = world_map) +
  geom_map(map = world_map,
           aes(x = long,
               y = lat,
               map_id = region),
           color = "white",
           size = 0.3,
           fill = "#22394A") +
  theme_void()

A little more complex world map

A world map with data

Using this week’s TidyTuesday data!

library(dplyr)
owid_energy <- 
  readr::read_csv('https://raw.githubusercontent.com/rfordatascience/tidytuesday/master/data/2023/2023-06-06/owid-energy.csv')

owid_energy_2021 <-
  owid_energy |>
  filter(year == 2021) |>
  mutate(
    country =
      case_match(
        country,
        "United States" ~ "USA",
        "United Kingdom" ~ "UK",
        "Cote d'Ivoire" ~ "Ivory Coast",
        "Democratic Republic of Congo" ~ "Democratic Republic of the Congo",
        "Congo" ~ "Republic of Congo",
        "Czechia" ~ "Czech Republic",
        .default = country
      )
  )

A world map with data

world_energy <- 
  map_data("world") |>
  left_join(owid_energy_2021, join_by(region == country))

A world map with data

ggplot(data = world_energy,)+
  geom_map(map = world_energy,
           aes(x = long,
               y = lat, 
               map_id = region,
               fill = per_capita_electricity),
           color = "white", 
           size = 0.3)

A world map with data and style

library(MexBrewer)

ggplot(data = world_energy) +
  geom_map(map = world_energy,
           aes(x = long,
               y = lat, 
               map_id = region,
               fill = log(per_capita_electricity)),
           color = "white", 
           size = 0.3) +
  scale_fill_gradientn(colors = mex.brewer("Revolucion"),
                       name = "1000's of kWh") +
  theme_void() +
  theme(legend.position="bottom") +
  labs(title = "Energy use per person, 2021",
       subtitle = "Energy use not only includes electricity, but other also areas of consumption including transport, heating, and cooking.")

A world map with data and style

A U.S. map

library(ggplot2)
library(maps)

state <- map_data("state")

ggplot(data = state) +
  geom_map(map = state,
           aes(x = long, 
               y = lat, 
               map_id = region),
           color = "white") +
  ggtitle("U.S. Map")

A U.S. map

A U.S. map with data

library(dplyr)

us_data_2023 <-
  readxl::read_excel("data/table_5_04_b.xlsx",
                     skip = 3) |> 
  transmute(state = tolower(`Census Division\r\nand State`),
         energy = `March 2023 YTD...2`)

us_map <- 
  map_data("state") |>
  left_join(us_data_2023, join_by(region == state))

head(us_map)

       long      lat group order  region subregion energy
1 -87.46201 30.38968     1     1 alabama      <NA>   7358
2 -87.48493 30.37249     1     2 alabama      <NA>   7358
3 -87.52503 30.37249     1     3 alabama      <NA>   7358
4 -87.53076 30.33239     1     4 alabama      <NA>   7358
5 -87.57087 30.32665     1     5 alabama      <NA>   7358
6 -87.58806 30.32665     1     6 alabama      <NA>   7358

A U.S. map with data

library(ggplot2)
library(maps)

ggplot(data = us_map) +
  geom_map(map = us_map,
           aes(x = long, 
               y = lat, 
               map_id = region,
               fill = energy),
           color = "white") +
  ggtitle("U.S. Map") +
  theme_void()

A U.S. map with data

Color scales

Seven essential Excel data visualization tips

Image bar chart
Geographical heat map
Color scales
Sparklines
REPT Charts
Data bars
Icon sets

Color scales

Also known as “heatmaps”.

A heatmap with ggplot2

USPersonalExpenditure

                      1940   1945  1950 1955  1960
Food and Tobacco    22.200 44.500 59.60 73.2 86.80
Household Operation 10.500 15.500 29.00 36.5 46.20
Medical and Health   3.530  5.760  9.71 14.0 21.10
Personal Care        1.040  1.980  2.45  3.4  5.40
Private Education    0.341  0.974  1.80  2.6  3.64

A heatmap with ggplot2

library(tidyr)

upe <-
  USPersonalExpenditure |> 
  as_tibble(rownames = NA) |> 
  tibble::rownames_to_column("categories") |> 
  pivot_longer(cols = `1940`:`1960`,
               names_to = "year",
               values_to = "expenditures")

head(upe)

# A tibble: 6 × 3
  categories          year  expenditures
  <chr>               <chr>        <dbl>
1 Food and Tobacco    1940          22.2
2 Food and Tobacco    1945          44.5
3 Food and Tobacco    1950          59.6
4 Food and Tobacco    1955          73.2
5 Food and Tobacco    1960          86.8
6 Household Operation 1940          10.5

A heatmap with ggplot2

library(ggplot2)

ggplot(data = upe, 
       aes(x = year, 
           y = categories, 
           fill = expenditures)) +
  geom_tile() +
  scale_fill_gradient(low = "#368990",
                      high = "#F4C659",
                      guide = "none")

A heatmap with ggplot2

A heatmap with ggplot2

ggplot(data = upe,
       aes(x = year,
           y = categories,
           fill = expenditures)) +
  geom_tile(color = "white",
            size = 0.3) +
  scale_fill_gradient(low = "#368990",
                      high = "#F4C659",
                      guide = "none") +
  theme(axis.title.x = element_blank(),
        axis.title.y = element_blank())

A heatmap with ggplot2

A heatmap with ggplot2

ggplot(data = upe,
       aes(x = year,
           y = categories,
           fill = expenditures)) +
  geom_tile(color = "white",
            size = 0.3) +
  geom_text(aes(label = scales::dollar(expenditures)),
            color = "white") +
  scale_fill_gradient(low = "#368990",
                      high = "#F4C659",
                      guide = "none") +
  theme_minimal() +
  theme(axis.title.x = element_blank(),
        axis.title.y = element_blank()) +
  labs(title = "United States Personal Expenditures",
       subtitle = "(in billions of dollars)")

A heatmap with ggplot2

But what if we already have a table?

upe_original <-
  USPersonalExpenditure |> 
  as_tibble(rownames = NA) |>  
  tibble::rownames_to_column("categories") 

upe_original

# A tibble: 5 × 6
  categories          `1940` `1945` `1950` `1955` `1960`
  <chr>                <dbl>  <dbl>  <dbl>  <dbl>  <dbl>
1 Food and Tobacco    22.2   44.5    59.6    73.2  86.8 
2 Household Operation 10.5   15.5    29      36.5  46.2 
3 Medical and Health   3.53   5.76    9.71   14    21.1 
4 Personal Care        1.04   1.98    2.45    3.4   5.4 
5 Private Education    0.341  0.974   1.8     2.6   3.64

Hello, gt!

library(gt)

upe_original |> 
  gt()

categories	1940	1945	1950	1955	1960
Food and Tobacco	22.200	44.500	59.60	73.2	86.80
Household Operation	10.500	15.500	29.00	36.5	46.20
Medical and Health	3.530	5.760	9.71	14.0	21.10
Personal Care	1.040	1.980	2.45	3.4	5.40
Private Education	0.341	0.974	1.80	2.6	3.64

A heatmap with gt and gtExtras

library(gt)

upe_original |> 
  gt() |> 
  data_color(columns = `1940`:`1960`, 
             palette = c("#368990", "#F4C659"))

categories	1940	1945	1950	1955	1960
Food and Tobacco	22.200	44.500	59.60	73.2	86.80
Household Operation	10.500	15.500	29.00	36.5	46.20
Medical and Health	3.530	5.760	9.71	14.0	21.10
Personal Care	1.040	1.980	2.45	3.4	5.40
Private Education	0.341	0.974	1.80	2.6	3.64

A heatmap with gt

library(gt)

upe_original |>
  gt(rowname_col = "categories") |>
  data_color(columns = `1940`:`1960`, 
             palette = c("#368990", "#F4C659")) |> 
  fmt_currency(`1940`:`1960`)

	1940	1945	1950	1955	1960
Food and Tobacco	$22.20	$44.50	$59.60	$73.20	$86.80
Household Operation	$10.50	$15.50	$29.00	$36.50	$46.20
Medical and Health	$3.53	$5.76	$9.71	$14.00	$21.10
Personal Care	$1.04	$1.98	$2.45	$3.40	$5.40
Private Education	$0.34	$0.97	$1.80	$2.60	$3.64

A heatmap with gt and gtExtras

library(gt)

upe_original |>
  gt(rowname_col = "categories") |>
  data_color(
    columns = `1940`:`1960`,
    palette = c("#368990", "#F4C659")) |> 
  fmt_currency(`1940`:`1960`) |> 
  tab_header(title = "United States Personal Expenditures",
             subtitle = "(in billions of dollars)")

	1940	1945	1950	1955	1960
United States Personal Expenditures
(in billions of dollars)
Food and Tobacco	$22.20	$44.50	$59.60	$73.20	$86.80
Household Operation	$10.50	$15.50	$29.00	$36.50	$46.20
Medical and Health	$3.53	$5.76	$9.71	$14.00	$21.10
Personal Care	$1.04	$1.98	$2.45	$3.40	$5.40
Private Education	$0.34	$0.97	$1.80	$2.60	$3.64

Sparklines

Seven essential Excel data visualization tips

Image bar chart
Geographical heat map
Color scales
Sparklines
REPT Charts
Data bars
Icon sets

Sparklines

Sparklines with ggplot2

glimpse(ca_np)

Rows: 789
Columns: 7
$ region    <chr> "PW", "PW", "PW", "PW", "PW", "PW", "PW", "PW", "PW", "PW", …
$ state     <chr> "CA", "CA", "CA", "CA", "CA", "CA", "CA", "CA", "CA", "CA", …
$ code      <chr> "CHIS", "CHIS", "CHIS", "CHIS", "CHIS", "CHIS", "CHIS", "CHI…
$ park_name <chr> "Channel Islands National Park", "Channel Islands National P…
$ type      <chr> "National Park", "National Park", "National Park", "National…
$ visitors  <dbl> 1200, 1500, 1600, 300, 15700, 31000, 33100, 32000, 24400, 31…
$ year      <dbl> 1963, 1964, 1965, 1966, 1967, 1968, 1969, 1970, 1971, 1972, …

Sparklines with ggplot2

library(ggplot2)
library(dplyr)

ggplot(data = ca_np) +
  geom_line(aes(x = year, 
                y = visitors))

Sparklines with ggplot2

library(ggplot2)
library(dplyr)

ggplot(data = ca_np) +
  geom_line(aes(x = year, 
                y = visitors, 
                group = park_name))

Sparklines with ggplot2

ggplot(data = ca_np) +
  geom_line(aes(x = year, 
                y = visitors, 
                group = park_name)) +
  facet_wrap(park_name ~ .)

Hello, gtExtras!

7 themes that style almost every element of a gt table
Helper functions for aligning/padding numbers, adding fontawesome icons, images, highlighting, and more
12 plotting functions for inline sparklines, win-loss charts, and more

…and way more!

Sparklines with gt

library(gt)
library(gtExtras)

ca_np |>
  gt()

region	state	code	park_name	type	visitors	year
PW	CA	CHIS	Channel Islands National Park	National Park	1200	1963
PW	CA	CHIS	Channel Islands National Park	National Park	1500	1964
PW	CA	CHIS	Channel Islands National Park	National Park	1600	1965
PW	CA	CHIS	Channel Islands National Park	National Park	300	1966
PW	CA	CHIS	Channel Islands National Park	National Park	15700	1967
PW	CA	CHIS	Channel Islands National Park	National Park	31000	1968
PW	CA	CHIS	Channel Islands National Park	National Park	33100	1969
PW	CA	CHIS	Channel Islands National Park	National Park	32000	1970
PW	CA	CHIS	Channel Islands National Park	National Park	24400	1971
PW	CA	CHIS	Channel Islands National Park	National Park	31947	1972
PW	CA	CHIS	Channel Islands National Park	National Park	44700	1973
PW	CA	CHIS	Channel Islands National Park	National Park	31000	1974
PW	CA	CHIS	Channel Islands National Park	National Park	74400	1975
PW	CA	CHIS	Channel Islands National Park	National Park	92600	1976
PW	CA	CHIS	Channel Islands National Park	National Park	87200	1977
PW	CA	CHIS	Channel Islands National Park	National Park	46416	1978
PW	CA	CHIS	Channel Islands National Park	National Park	82937	1979
PW	CA	CHIS	Channel Islands National Park	National Park	104574	1980
PW	CA	CHIS	Channel Islands National Park	National Park	87514	1981
PW	CA	CHIS	Channel Islands National Park	National Park	172287	1982
PW	CA	CHIS	Channel Islands National Park	National Park	205024	1983
PW	CA	CHIS	Channel Islands National Park	National Park	203411	1984
PW	CA	CHIS	Channel Islands National Park	National Park	164132	1985
PW	CA	CHIS	Channel Islands National Park	National Park	172913	1986
PW	CA	CHIS	Channel Islands National Park	National Park	174607	1987
PW	CA	CHIS	Channel Islands National Park	National Park	168592	1988
PW	CA	CHIS	Channel Islands National Park	National Park	152662	1989
PW	CA	CHIS	Channel Islands National Park	National Park	144083	1990
PW	CA	CHIS	Channel Islands National Park	National Park	149263	1991
PW	CA	CHIS	Channel Islands National Park	National Park	169181	1992
PW	CA	CHIS	Channel Islands National Park	National Park	184867	1993
PW	CA	CHIS	Channel Islands National Park	National Park	175226	1994
PW	CA	CHIS	Channel Islands National Park	National Park	525882	1995
PW	CA	CHIS	Channel Islands National Park	National Park	490715	1996
PW	CA	CHIS	Channel Islands National Park	National Park	488757	1997
PW	CA	CHIS	Channel Islands National Park	National Park	574270	1998
PW	CA	CHIS	Channel Islands National Park	National Park	607057	1999
PW	CA	CHIS	Channel Islands National Park	National Park	482571	2000
PW	CA	CHIS	Channel Islands National Park	National Park	520428	2001
PW	CA	CHIS	Channel Islands National Park	National Park	613935	2002
PW	CA	CHIS	Channel Islands National Park	National Park	585919	2003
PW	CA	CHIS	Channel Islands National Park	National Park	537716	2004
PW	CA	CHIS	Channel Islands National Park	National Park	434107	2005
PW	CA	CHIS	Channel Islands National Park	National Park	375256	2006
PW	CA	CHIS	Channel Islands National Park	National Park	360806	2007
PW	CA	CHIS	Channel Islands National Park	National Park	332177	2008
PW	CA	CHIS	Channel Islands National Park	National Park	348745	2009
PW	CA	CHIS	Channel Islands National Park	National Park	277515	2010
PW	CA	CHIS	Channel Islands National Park	National Park	242756	2011
PW	CA	CHIS	Channel Islands National Park	National Park	249594	2012
PW	CA	CHIS	Channel Islands National Park	National Park	212029	2013
PW	CA	CHIS	Channel Islands National Park	National Park	342161	2014
PW	CA	CHIS	Channel Islands National Park	National Park	324816	2015
PW	CA	CHIS	Channel Islands National Park	National Park	364807	2016
PW	CA	DEVA	Death Valley National Park	National Park	9970	1933
PW	CA	DEVA	Death Valley National Park	National Park	19678	1934
PW	CA	DEVA	Death Valley National Park	National Park	42061	1935
PW	CA	DEVA	Death Valley National Park	National Park	40815	1936
PW	CA	DEVA	Death Valley National Park	National Park	48874	1937
PW	CA	DEVA	Death Valley National Park	National Park	58320	1938
PW	CA	DEVA	Death Valley National Park	National Park	61301	1939
PW	CA	DEVA	Death Valley National Park	National Park	80842	1940
PW	CA	DEVA	Death Valley National Park	National Park	100829	1941
PW	CA	DEVA	Death Valley National Park	National Park	44755	1942
PW	CA	DEVA	Death Valley National Park	National Park	14374	1943
PW	CA	DEVA	Death Valley National Park	National Park	13661	1944
PW	CA	DEVA	Death Valley National Park	National Park	31112	1945
PW	CA	DEVA	Death Valley National Park	National Park	100976	1946
PW	CA	DEVA	Death Valley National Park	National Park	161953	1947
PW	CA	DEVA	Death Valley National Park	National Park	162150	1948
PW	CA	DEVA	Death Valley National Park	National Park	208557	1949
PW	CA	DEVA	Death Valley National Park	National Park	189045	1950
PW	CA	DEVA	Death Valley National Park	National Park	219520	1951
PW	CA	DEVA	Death Valley National Park	National Park	296106	1952
PW	CA	DEVA	Death Valley National Park	National Park	338899	1953
PW	CA	DEVA	Death Valley National Park	National Park	337900	1954
PW	CA	DEVA	Death Valley National Park	National Park	342200	1955
PW	CA	DEVA	Death Valley National Park	National Park	300100	1956
PW	CA	DEVA	Death Valley National Park	National Park	333400	1957
PW	CA	DEVA	Death Valley National Park	National Park	334300	1958
PW	CA	DEVA	Death Valley National Park	National Park	335700	1959
PW	CA	DEVA	Death Valley National Park	National Park	355900	1960
PW	CA	DEVA	Death Valley National Park	National Park	397900	1961
PW	CA	DEVA	Death Valley National Park	National Park	363400	1962
PW	CA	DEVA	Death Valley National Park	National Park	408100	1963
PW	CA	DEVA	Death Valley National Park	National Park	403600	1964
PW	CA	DEVA	Death Valley National Park	National Park	453000	1965
PW	CA	DEVA	Death Valley National Park	National Park	437800	1966
PW	CA	DEVA	Death Valley National Park	National Park	476700	1967
PW	CA	DEVA	Death Valley National Park	National Park	469600	1968
PW	CA	DEVA	Death Valley National Park	National Park	458800	1969
PW	CA	DEVA	Death Valley National Park	National Park	580500	1970
PW	CA	DEVA	Death Valley National Park	National Park	290900	1971
PW	CA	DEVA	Death Valley National Park	National Park	293999	1972
PW	CA	DEVA	Death Valley National Park	National Park	315400	1973
PW	CA	DEVA	Death Valley National Park	National Park	368800	1974
PW	CA	DEVA	Death Valley National Park	National Park	545500	1975
PW	CA	DEVA	Death Valley National Park	National Park	582400	1976
PW	CA	DEVA	Death Valley National Park	National Park	620400	1977
PW	CA	DEVA	Death Valley National Park	National Park	673610	1978
PW	CA	DEVA	Death Valley National Park	National Park	631152	1979
PW	CA	DEVA	Death Valley National Park	National Park	618140	1980
PW	CA	DEVA	Death Valley National Park	National Park	630402	1981
PW	CA	DEVA	Death Valley National Park	National Park	679992	1982
PW	CA	DEVA	Death Valley National Park	National Park	635582	1983
PW	CA	DEVA	Death Valley National Park	National Park	621197	1984
PW	CA	DEVA	Death Valley National Park	National Park	576679	1985
PW	CA	DEVA	Death Valley National Park	National Park	586668	1986
PW	CA	DEVA	Death Valley National Park	National Park	665345	1987
PW	CA	DEVA	Death Valley National Park	National Park	692267	1988
PW	CA	DEVA	Death Valley National Park	National Park	664449	1989
PW	CA	DEVA	Death Valley National Park	National Park	690965	1990
PW	CA	DEVA	Death Valley National Park	National Park	743608	1991
PW	CA	DEVA	Death Valley National Park	National Park	869183	1992
PW	CA	DEVA	Death Valley National Park	National Park	998474	1993
PW	CA	DEVA	Death Valley National Park	National Park	971487	1994
PW	CA	DEVA	Death Valley National Park	National Park	1109421	1995
PW	CA	DEVA	Death Valley National Park	National Park	1189215	1996
PW	CA	DEVA	Death Valley National Park	National Park	1188212	1997
PW	CA	DEVA	Death Valley National Park	National Park	1177746	1998
PW	CA	DEVA	Death Valley National Park	National Park	1227583	1999
PW	CA	DEVA	Death Valley National Park	National Park	1179094	2000
PW	CA	DEVA	Death Valley National Park	National Park	1014636	2001
PW	CA	DEVA	Death Valley National Park	National Park	897596	2002
PW	CA	DEVA	Death Valley National Park	National Park	890375	2003
PW	CA	DEVA	Death Valley National Park	National Park	764820	2004
PW	CA	DEVA	Death Valley National Park	National Park	800113	2005
PW	CA	DEVA	Death Valley National Park	National Park	744440	2006
PW	CA	DEVA	Death Valley National Park	National Park	704122	2007
PW	CA	DEVA	Death Valley National Park	National Park	871938	2008
PW	CA	DEVA	Death Valley National Park	National Park	828574	2009
PW	CA	DEVA	Death Valley National Park	National Park	984775	2010
PW	CA	DEVA	Death Valley National Park	National Park	946867	2011
PW	CA	DEVA	Death Valley National Park	National Park	984568	2012
PW	CA	DEVA	Death Valley National Park	National Park	951972	2013
PW	CA	DEVA	Death Valley National Park	National Park	1101312	2014
PW	CA	DEVA	Death Valley National Park	National Park	1154843	2015
PW	CA	DEVA	Death Valley National Park	National Park	1296283	2016
PW	CA	JOTR	Joshua Tree National Park	National Park	31285	1941
PW	CA	JOTR	Joshua Tree National Park	National Park	23691	1942
PW	CA	JOTR	Joshua Tree National Park	National Park	17414	1943
PW	CA	JOTR	Joshua Tree National Park	National Park	7640	1944
PW	CA	JOTR	Joshua Tree National Park	National Park	18275	1945
PW	CA	JOTR	Joshua Tree National Park	National Park	36605	1946
PW	CA	JOTR	Joshua Tree National Park	National Park	57801	1947
PW	CA	JOTR	Joshua Tree National Park	National Park	59157	1948
PW	CA	JOTR	Joshua Tree National Park	National Park	66991	1949
PW	CA	JOTR	Joshua Tree National Park	National Park	79129	1950
PW	CA	JOTR	Joshua Tree National Park	National Park	93615	1951
PW	CA	JOTR	Joshua Tree National Park	National Park	141416	1952
PW	CA	JOTR	Joshua Tree National Park	National Park	172423	1953
PW	CA	JOTR	Joshua Tree National Park	National Park	260700	1954
PW	CA	JOTR	Joshua Tree National Park	National Park	280600	1955
PW	CA	JOTR	Joshua Tree National Park	National Park	312900	1956
PW	CA	JOTR	Joshua Tree National Park	National Park	320300	1957
PW	CA	JOTR	Joshua Tree National Park	National Park	365300	1958
PW	CA	JOTR	Joshua Tree National Park	National Park	299600	1959
PW	CA	JOTR	Joshua Tree National Park	National Park	320100	1960
PW	CA	JOTR	Joshua Tree National Park	National Park	301500	1961
PW	CA	JOTR	Joshua Tree National Park	National Park	331500	1962
PW	CA	JOTR	Joshua Tree National Park	National Park	346300	1963
PW	CA	JOTR	Joshua Tree National Park	National Park	343400	1964
PW	CA	JOTR	Joshua Tree National Park	National Park	336000	1965
PW	CA	JOTR	Joshua Tree National Park	National Park	408600	1966
PW	CA	JOTR	Joshua Tree National Park	National Park	416500	1967
PW	CA	JOTR	Joshua Tree National Park	National Park	489400	1968
PW	CA	JOTR	Joshua Tree National Park	National Park	550300	1969
PW	CA	JOTR	Joshua Tree National Park	National Park	643000	1970
PW	CA	JOTR	Joshua Tree National Park	National Park	576000	1971
PW	CA	JOTR	Joshua Tree National Park	National Park	602752	1972
PW	CA	JOTR	Joshua Tree National Park	National Park	589600	1973
PW	CA	JOTR	Joshua Tree National Park	National Park	509900	1974
PW	CA	JOTR	Joshua Tree National Park	National Park	552200	1975
PW	CA	JOTR	Joshua Tree National Park	National Park	728900	1976
PW	CA	JOTR	Joshua Tree National Park	National Park	745600	1977
PW	CA	JOTR	Joshua Tree National Park	National Park	602453	1978
PW	CA	JOTR	Joshua Tree National Park	National Park	590543	1979
PW	CA	JOTR	Joshua Tree National Park	National Park	545357	1980
PW	CA	JOTR	Joshua Tree National Park	National Park	612966	1981
PW	CA	JOTR	Joshua Tree National Park	National Park	673201	1982
PW	CA	JOTR	Joshua Tree National Park	National Park	671426	1983
PW	CA	JOTR	Joshua Tree National Park	National Park	663798	1984
PW	CA	JOTR	Joshua Tree National Park	National Park	641172	1985
PW	CA	JOTR	Joshua Tree National Park	National Park	783224	1986
PW	CA	JOTR	Joshua Tree National Park	National Park	830085	1987
PW	CA	JOTR	Joshua Tree National Park	National Park	955246	1988
PW	CA	JOTR	Joshua Tree National Park	National Park	990214	1989
PW	CA	JOTR	Joshua Tree National Park	National Park	1022396	1990
PW	CA	JOTR	Joshua Tree National Park	National Park	1145458	1991
PW	CA	JOTR	Joshua Tree National Park	National Park	1220539	1992
PW	CA	JOTR	Joshua Tree National Park	National Park	1252401	1993
PW	CA	JOTR	Joshua Tree National Park	National Park	1184871	1994
PW	CA	JOTR	Joshua Tree National Park	National Park	1235702	1995
PW	CA	JOTR	Joshua Tree National Park	National Park	1095046	1996
PW	CA	JOTR	Joshua Tree National Park	National Park	1226273	1997
PW	CA	JOTR	Joshua Tree National Park	National Park	1410312	1998
PW	CA	JOTR	Joshua Tree National Park	National Park	1316340	1999
PW	CA	JOTR	Joshua Tree National Park	National Park	1233935	2000
PW	CA	JOTR	Joshua Tree National Park	National Park	1280917	2001
PW	CA	JOTR	Joshua Tree National Park	National Park	1178376	2002
PW	CA	JOTR	Joshua Tree National Park	National Park	1283346	2003
PW	CA	JOTR	Joshua Tree National Park	National Park	1243659	2004
PW	CA	JOTR	Joshua Tree National Park	National Park	1375111	2005
PW	CA	JOTR	Joshua Tree National Park	National Park	1256421	2006
PW	CA	JOTR	Joshua Tree National Park	National Park	1298979	2007
PW	CA	JOTR	Joshua Tree National Park	National Park	1392446	2008
PW	CA	JOTR	Joshua Tree National Park	National Park	1304471	2009
PW	CA	JOTR	Joshua Tree National Park	National Park	1434976	2010
PW	CA	JOTR	Joshua Tree National Park	National Park	1396237	2011
PW	CA	JOTR	Joshua Tree National Park	National Park	1396117	2012
PW	CA	JOTR	Joshua Tree National Park	National Park	1383340	2013
PW	CA	JOTR	Joshua Tree National Park	National Park	1589904	2014
PW	CA	JOTR	Joshua Tree National Park	National Park	2025756	2015
PW	CA	JOTR	Joshua Tree National Park	National Park	2505286	2016
PW	CA	KICA	Kings Canyon National Park	National Park	1000	1904
PW	CA	KICA	Kings Canyon National Park	National Park	1000	1905
PW	CA	KICA	Kings Canyon National Park	National Park	900	1906
PW	CA	KICA	Kings Canyon National Park	National Park	1100	1907
PW	CA	KICA	Kings Canyon National Park	National Park	1773	1908
PW	CA	KICA	Kings Canyon National Park	National Park	798	1909
PW	CA	KICA	Kings Canyon National Park	National Park	1178	1910
PW	CA	KICA	Kings Canyon National Park	National Park	2160	1911
PW	CA	KICA	Kings Canyon National Park	National Park	2240	1912
PW	CA	KICA	Kings Canyon National Park	National Park	2756	1913
PW	CA	KICA	Kings Canyon National Park	National Park	3735	1914
PW	CA	KICA	Kings Canyon National Park	National Park	10523	1915
PW	CA	KICA	Kings Canyon National Park	National Park	15360	1916
PW	CA	KICA	Kings Canyon National Park	National Park	17390	1917
PW	CA	KICA	Kings Canyon National Park	National Park	15496	1918
PW	CA	KICA	Kings Canyon National Park	National Park	21574	1919
PW	CA	KICA	Kings Canyon National Park	National Park	19661	1920
PW	CA	KICA	Kings Canyon National Park	National Park	30312	1921
PW	CA	KICA	Kings Canyon National Park	National Park	50456	1922
PW	CA	KICA	Kings Canyon National Park	National Park	46230	1923
PW	CA	KICA	Kings Canyon National Park	National Park	35020	1924
PW	CA	KICA	Kings Canyon National Park	National Park	40517	1925
PW	CA	KICA	Kings Canyon National Park	National Park	50597	1926
PW	CA	KICA	Kings Canyon National Park	National Park	47996	1927
PW	CA	KICA	Kings Canyon National Park	National Park	51988	1928
PW	CA	KICA	Kings Canyon National Park	National Park	44783	1929
PW	CA	KICA	Kings Canyon National Park	National Park	43547	1930
PW	CA	KICA	Kings Canyon National Park	National Park	51995	1931
PW	CA	KICA	Kings Canyon National Park	National Park	40806	1932
PW	CA	KICA	Kings Canyon National Park	National Park	50081	1933
PW	CA	KICA	Kings Canyon National Park	National Park	66024	1934
PW	CA	KICA	Kings Canyon National Park	National Park	116739	1935
PW	CA	KICA	Kings Canyon National Park	National Park	148568	1936
PW	CA	KICA	Kings Canyon National Park	National Park	157810	1937
PW	CA	KICA	Kings Canyon National Park	National Park	148116	1938
PW	CA	KICA	Kings Canyon National Park	National Park	161080	1939
PW	CA	KICA	Kings Canyon National Park	National Park	201545	1940
PW	CA	KICA	Kings Canyon National Park	National Park	173587	1941
PW	CA	KICA	Kings Canyon National Park	National Park	97745	1942
PW	CA	KICA	Kings Canyon National Park	National Park	60651	1943
PW	CA	KICA	Kings Canyon National Park	National Park	35203	1944
PW	CA	KICA	Kings Canyon National Park	National Park	82442	1945
PW	CA	KICA	Kings Canyon National Park	National Park	221990	1946
PW	CA	KICA	Kings Canyon National Park	National Park	236687	1947
PW	CA	KICA	Kings Canyon National Park	National Park	279231	1948
PW	CA	KICA	Kings Canyon National Park	National Park	294021	1949
PW	CA	KICA	Kings Canyon National Park	National Park	337840	1950
PW	CA	KICA	Kings Canyon National Park	National Park	450031	1951
PW	CA	KICA	Kings Canyon National Park	National Park	448156	1952
PW	CA	KICA	Kings Canyon National Park	National Park	435548	1953
PW	CA	KICA	Kings Canyon National Park	National Park	551500	1954
PW	CA	KICA	Kings Canyon National Park	National Park	556100	1955
PW	CA	KICA	Kings Canyon National Park	National Park	669800	1956
PW	CA	KICA	Kings Canyon National Park	National Park	638500	1957
PW	CA	KICA	Kings Canyon National Park	National Park	683900	1958
PW	CA	KICA	Kings Canyon National Park	National Park	718500	1959
PW	CA	KICA	Kings Canyon National Park	National Park	759800	1960
PW	CA	KICA	Kings Canyon National Park	National Park	748600	1961
PW	CA	KICA	Kings Canyon National Park	National Park	826100	1962
PW	CA	KICA	Kings Canyon National Park	National Park	778600	1963
PW	CA	KICA	Kings Canyon National Park	National Park	831600	1964
PW	CA	KICA	Kings Canyon National Park	National Park	848900	1965
PW	CA	KICA	Kings Canyon National Park	National Park	923400	1966
PW	CA	KICA	Kings Canyon National Park	National Park	909900	1967
PW	CA	KICA	Kings Canyon National Park	National Park	1064000	1968
PW	CA	KICA	Kings Canyon National Park	National Park	946000	1969
PW	CA	KICA	Kings Canyon National Park	National Park	1019000	1970
PW	CA	KICA	Kings Canyon National Park	National Park	887000	1971
PW	CA	KICA	Kings Canyon National Park	National Park	1051755	1972
PW	CA	KICA	Kings Canyon National Park	National Park	899300	1973
PW	CA	KICA	Kings Canyon National Park	National Park	1216800	1974
PW	CA	KICA	Kings Canyon National Park	National Park	1031500	1975
PW	CA	KICA	Kings Canyon National Park	National Park	1127900	1976
PW	CA	KICA	Kings Canyon National Park	National Park	1041000	1977
PW	CA	KICA	Kings Canyon National Park	National Park	864733	1978
PW	CA	KICA	Kings Canyon National Park	National Park	804175	1979
PW	CA	KICA	Kings Canyon National Park	National Park	819065	1980
PW	CA	KICA	Kings Canyon National Park	National Park	776850	1981
PW	CA	KICA	Kings Canyon National Park	National Park	831044	1982
PW	CA	KICA	Kings Canyon National Park	National Park	765755	1983
PW	CA	KICA	Kings Canyon National Park	National Park	937262	1984
PW	CA	KICA	Kings Canyon National Park	National Park	874456	1985
PW	CA	KICA	Kings Canyon National Park	National Park	1028785	1986
PW	CA	KICA	Kings Canyon National Park	National Park	1081172	1987
PW	CA	KICA	Kings Canyon National Park	National Park	1007695	1988
PW	CA	KICA	Kings Canyon National Park	National Park	1037349	1989
PW	CA	KICA	Kings Canyon National Park	National Park	1062867	1990
PW	CA	KICA	Kings Canyon National Park	National Park	1071022	1991
PW	CA	KICA	Kings Canyon National Park	National Park	637446	1992
PW	CA	KICA	Kings Canyon National Park	National Park	636515	1993
PW	CA	KICA	Kings Canyon National Park	National Park	725930	1994
PW	CA	KICA	Kings Canyon National Park	National Park	832794	1995
PW	CA	KICA	Kings Canyon National Park	National Park	502749	1996
PW	CA	KICA	Kings Canyon National Park	National Park	484718	1997
PW	CA	KICA	Kings Canyon National Park	National Park	540212	1998
PW	CA	KICA	Kings Canyon National Park	National Park	559534	1999
PW	CA	KICA	Kings Canyon National Park	National Park	528987	2000
PW	CA	KICA	Kings Canyon National Park	National Park	541787	2001
PW	CA	KICA	Kings Canyon National Park	National Park	545420	2002
PW	CA	KICA	Kings Canyon National Park	National Park	555987	2003
PW	CA	KICA	Kings Canyon National Park	National Park	525035	2004
PW	CA	KICA	Kings Canyon National Park	National Park	594893	2005
PW	CA	KICA	Kings Canyon National Park	National Park	552766	2006
PW	CA	KICA	Kings Canyon National Park	National Park	580129	2007
PW	CA	KICA	Kings Canyon National Park	National Park	574870	2008
PW	CA	KICA	Kings Canyon National Park	National Park	609296	2009
PW	CA	KICA	Kings Canyon National Park	National Park	598205	2010
PW	CA	KICA	Kings Canyon National Park	National Park	566810	2011
PW	CA	KICA	Kings Canyon National Park	National Park	591033	2012
PW	CA	KICA	Kings Canyon National Park	National Park	567544	2013
PW	CA	KICA	Kings Canyon National Park	National Park	502268	2014
PW	CA	KICA	Kings Canyon National Park	National Park	468106	2015
PW	CA	KICA	Kings Canyon National Park	National Park	607479	2016
PW	CA	LAVO	Lassen Volcanic National Park	National Park	8500	1917
PW	CA	LAVO	Lassen Volcanic National Park	National Park	2000	1918
PW	CA	LAVO	Lassen Volcanic National Park	National Park	2500	1919
PW	CA	LAVO	Lassen Volcanic National Park	National Park	2000	1920
PW	CA	LAVO	Lassen Volcanic National Park	National Park	10000	1921
PW	CA	LAVO	Lassen Volcanic National Park	National Park	10000	1922
PW	CA	LAVO	Lassen Volcanic National Park	National Park	9500	1923
PW	CA	LAVO	Lassen Volcanic National Park	National Park	12500	1924
PW	CA	LAVO	Lassen Volcanic National Park	National Park	12596	1925
PW	CA	LAVO	Lassen Volcanic National Park	National Park	18739	1926
PW	CA	LAVO	Lassen Volcanic National Park	National Park	20089	1927
PW	CA	LAVO	Lassen Volcanic National Park	National Park	26057	1928
PW	CA	LAVO	Lassen Volcanic National Park	National Park	26106	1929
PW	CA	LAVO	Lassen Volcanic National Park	National Park	31755	1930
PW	CA	LAVO	Lassen Volcanic National Park	National Park	56833	1931
PW	CA	LAVO	Lassen Volcanic National Park	National Park	41723	1932
PW	CA	LAVO	Lassen Volcanic National Park	National Park	45577	1933
PW	CA	LAVO	Lassen Volcanic National Park	National Park	51906	1934
PW	CA	LAVO	Lassen Volcanic National Park	National Park	52294	1935
PW	CA	LAVO	Lassen Volcanic National Park	National Park	76971	1936
PW	CA	LAVO	Lassen Volcanic National Park	National Park	86757	1937
PW	CA	LAVO	Lassen Volcanic National Park	National Park	73005	1938
PW	CA	LAVO	Lassen Volcanic National Park	National Park	100880	1939
PW	CA	LAVO	Lassen Volcanic National Park	National Park	104619	1940
PW	CA	LAVO	Lassen Volcanic National Park	National Park	109272	1941
PW	CA	LAVO	Lassen Volcanic National Park	National Park	48144	1942
PW	CA	LAVO	Lassen Volcanic National Park	National Park	18971	1943
PW	CA	LAVO	Lassen Volcanic National Park	National Park	19060	1944
PW	CA	LAVO	Lassen Volcanic National Park	National Park	45225	1945
PW	CA	LAVO	Lassen Volcanic National Park	National Park	99067	1946
PW	CA	LAVO	Lassen Volcanic National Park	National Park	149848	1947
PW	CA	LAVO	Lassen Volcanic National Park	National Park	160707	1948
PW	CA	LAVO	Lassen Volcanic National Park	National Park	172496	1949
PW	CA	LAVO	Lassen Volcanic National Park	National Park	183815	1950
PW	CA	LAVO	Lassen Volcanic National Park	National Park	203609	1951
PW	CA	LAVO	Lassen Volcanic National Park	National Park	212550	1952
PW	CA	LAVO	Lassen Volcanic National Park	National Park	225328	1953
PW	CA	LAVO	Lassen Volcanic National Park	National Park	282400	1954
PW	CA	LAVO	Lassen Volcanic National Park	National Park	304400	1955
PW	CA	LAVO	Lassen Volcanic National Park	National Park	303800	1956
PW	CA	LAVO	Lassen Volcanic National Park	National Park	327300	1957
PW	CA	LAVO	Lassen Volcanic National Park	National Park	346700	1958
PW	CA	LAVO	Lassen Volcanic National Park	National Park	379900	1959
PW	CA	LAVO	Lassen Volcanic National Park	National Park	401800	1960
PW	CA	LAVO	Lassen Volcanic National Park	National Park	460000	1961
PW	CA	LAVO	Lassen Volcanic National Park	National Park	399000	1962
PW	CA	LAVO	Lassen Volcanic National Park	National Park	369300	1963
PW	CA	LAVO	Lassen Volcanic National Park	National Park	407700	1964
PW	CA	LAVO	Lassen Volcanic National Park	National Park	400300	1965
PW	CA	LAVO	Lassen Volcanic National Park	National Park	462500	1966
PW	CA	LAVO	Lassen Volcanic National Park	National Park	358300	1967
PW	CA	LAVO	Lassen Volcanic National Park	National Park	442800	1968
PW	CA	LAVO	Lassen Volcanic National Park	National Park	435700	1969
PW	CA	LAVO	Lassen Volcanic National Park	National Park	466600	1970
PW	CA	LAVO	Lassen Volcanic National Park	National Park	447400	1971
PW	CA	LAVO	Lassen Volcanic National Park	National Park	504641	1972
PW	CA	LAVO	Lassen Volcanic National Park	National Park	496200	1973
PW	CA	LAVO	Lassen Volcanic National Park	National Park	408700	1974
PW	CA	LAVO	Lassen Volcanic National Park	National Park	444500	1975
PW	CA	LAVO	Lassen Volcanic National Park	National Park	461400	1976
PW	CA	LAVO	Lassen Volcanic National Park	National Park	381200	1977
PW	CA	LAVO	Lassen Volcanic National Park	National Park	442192	1978
PW	CA	LAVO	Lassen Volcanic National Park	National Park	380014	1979
PW	CA	LAVO	Lassen Volcanic National Park	National Park	394425	1980
PW	CA	LAVO	Lassen Volcanic National Park	National Park	415045	1981
PW	CA	LAVO	Lassen Volcanic National Park	National Park	414859	1982
PW	CA	LAVO	Lassen Volcanic National Park	National Park	429867	1983
PW	CA	LAVO	Lassen Volcanic National Park	National Park	463275	1984
PW	CA	LAVO	Lassen Volcanic National Park	National Park	451497	1985
PW	CA	LAVO	Lassen Volcanic National Park	National Park	439723	1986
PW	CA	LAVO	Lassen Volcanic National Park	National Park	472431	1987
PW	CA	LAVO	Lassen Volcanic National Park	National Park	495628	1988
PW	CA	LAVO	Lassen Volcanic National Park	National Park	466115	1989
PW	CA	LAVO	Lassen Volcanic National Park	National Park	460917	1990
PW	CA	LAVO	Lassen Volcanic National Park	National Park	463179	1991
PW	CA	LAVO	Lassen Volcanic National Park	National Park	468011	1992
PW	CA	LAVO	Lassen Volcanic National Park	National Park	434264	1993
PW	CA	LAVO	Lassen Volcanic National Park	National Park	385489	1994
PW	CA	LAVO	Lassen Volcanic National Park	National Park	351001	1995
PW	CA	LAVO	Lassen Volcanic National Park	National Park	351632	1996
PW	CA	LAVO	Lassen Volcanic National Park	National Park	391816	1997
PW	CA	LAVO	Lassen Volcanic National Park	National Park	318049	1998
PW	CA	LAVO	Lassen Volcanic National Park	National Park	353756	1999
PW	CA	LAVO	Lassen Volcanic National Park	National Park	374911	2000
PW	CA	LAVO	Lassen Volcanic National Park	National Park	376695	2001
PW	CA	LAVO	Lassen Volcanic National Park	National Park	388149	2002
PW	CA	LAVO	Lassen Volcanic National Park	National Park	404384	2003
PW	CA	LAVO	Lassen Volcanic National Park	National Park	379667	2004
PW	CA	LAVO	Lassen Volcanic National Park	National Park	365535	2005
PW	CA	LAVO	Lassen Volcanic National Park	National Park	388741	2006
PW	CA	LAVO	Lassen Volcanic National Park	National Park	395057	2007
PW	CA	LAVO	Lassen Volcanic National Park	National Park	377361	2008
PW	CA	LAVO	Lassen Volcanic National Park	National Park	365639	2009
PW	CA	LAVO	Lassen Volcanic National Park	National Park	384570	2010
PW	CA	LAVO	Lassen Volcanic National Park	National Park	351269	2011
PW	CA	LAVO	Lassen Volcanic National Park	National Park	407653	2012
PW	CA	LAVO	Lassen Volcanic National Park	National Park	427409	2013
PW	CA	LAVO	Lassen Volcanic National Park	National Park	432977	2014
PW	CA	LAVO	Lassen Volcanic National Park	National Park	468092	2015
PW	CA	LAVO	Lassen Volcanic National Park	National Park	536068	2016
PW	CA	PINN	Pinnacles National Park	National Park	6500	1923
PW	CA	PINN	Pinnacles National Park	National Park	8973	1924
PW	CA	PINN	Pinnacles National Park	National Park	10000	1925
PW	CA	PINN	Pinnacles National Park	National Park	10167	1926
PW	CA	PINN	Pinnacles National Park	National Park	11265	1927
PW	CA	PINN	Pinnacles National Park	National Park	13216	1928
PW	CA	PINN	Pinnacles National Park	National Park	10756	1929
PW	CA	PINN	Pinnacles National Park	National Park	11862	1930
PW	CA	PINN	Pinnacles National Park	National Park	12813	1931
PW	CA	PINN	Pinnacles National Park	National Park	14238	1932
PW	CA	PINN	Pinnacles National Park	National Park	9957	1933
PW	CA	PINN	Pinnacles National Park	National Park	20129	1934
PW	CA	PINN	Pinnacles National Park	National Park	17872	1935
PW	CA	PINN	Pinnacles National Park	National Park	18614	1936
PW	CA	PINN	Pinnacles National Park	National Park	22426	1937
PW	CA	PINN	Pinnacles National Park	National Park	22266	1938
PW	CA	PINN	Pinnacles National Park	National Park	24717	1939
PW	CA	PINN	Pinnacles National Park	National Park	25068	1940
PW	CA	PINN	Pinnacles National Park	National Park	27131	1941
PW	CA	PINN	Pinnacles National Park	National Park	10311	1942
PW	CA	PINN	Pinnacles National Park	National Park	4570	1943
PW	CA	PINN	Pinnacles National Park	National Park	3845	1944
PW	CA	PINN	Pinnacles National Park	National Park	7494	1945
PW	CA	PINN	Pinnacles National Park	National Park	16298	1946
PW	CA	PINN	Pinnacles National Park	National Park	18328	1947
PW	CA	PINN	Pinnacles National Park	National Park	20331	1948
PW	CA	PINN	Pinnacles National Park	National Park	24557	1949
PW	CA	PINN	Pinnacles National Park	National Park	24814	1950
PW	CA	PINN	Pinnacles National Park	National Park	27090	1951
PW	CA	PINN	Pinnacles National Park	National Park	28236	1952
PW	CA	PINN	Pinnacles National Park	National Park	42199	1953
PW	CA	PINN	Pinnacles National Park	National Park	38300	1954
PW	CA	PINN	Pinnacles National Park	National Park	36500	1955
PW	CA	PINN	Pinnacles National Park	National Park	40300	1956
PW	CA	PINN	Pinnacles National Park	National Park	53200	1957
PW	CA	PINN	Pinnacles National Park	National Park	54900	1958
PW	CA	PINN	Pinnacles National Park	National Park	71400	1959
PW	CA	PINN	Pinnacles National Park	National Park	72000	1960
PW	CA	PINN	Pinnacles National Park	National Park	76900	1961
PW	CA	PINN	Pinnacles National Park	National Park	81500	1962
PW	CA	PINN	Pinnacles National Park	National Park	97000	1963
PW	CA	PINN	Pinnacles National Park	National Park	103200	1964
PW	CA	PINN	Pinnacles National Park	National Park	118000	1965
PW	CA	PINN	Pinnacles National Park	National Park	117900	1966
PW	CA	PINN	Pinnacles National Park	National Park	160600	1967
PW	CA	PINN	Pinnacles National Park	National Park	147000	1968
PW	CA	PINN	Pinnacles National Park	National Park	147000	1969
PW	CA	PINN	Pinnacles National Park	National Park	166200	1970
PW	CA	PINN	Pinnacles National Park	National Park	169200	1971
PW	CA	PINN	Pinnacles National Park	National Park	168896	1972
PW	CA	PINN	Pinnacles National Park	National Park	155500	1973
PW	CA	PINN	Pinnacles National Park	National Park	138500	1974
PW	CA	PINN	Pinnacles National Park	National Park	162200	1975
PW	CA	PINN	Pinnacles National Park	National Park	156900	1976
PW	CA	PINN	Pinnacles National Park	National Park	160500	1977
PW	CA	PINN	Pinnacles National Park	National Park	155822	1978
PW	CA	PINN	Pinnacles National Park	National Park	153717	1979
PW	CA	PINN	Pinnacles National Park	National Park	163626	1980
PW	CA	PINN	Pinnacles National Park	National Park	155205	1981
PW	CA	PINN	Pinnacles National Park	National Park	171026	1982
PW	CA	PINN	Pinnacles National Park	National Park	170631	1983
PW	CA	PINN	Pinnacles National Park	National Park	166258	1984
PW	CA	PINN	Pinnacles National Park	National Park	191578	1985
PW	CA	PINN	Pinnacles National Park	National Park	198236	1986
PW	CA	PINN	Pinnacles National Park	National Park	204705	1987
PW	CA	PINN	Pinnacles National Park	National Park	212094	1988
PW	CA	PINN	Pinnacles National Park	National Park	218601	1989
PW	CA	PINN	Pinnacles National Park	National Park	214268	1990
PW	CA	PINN	Pinnacles National Park	National Park	192610	1991
PW	CA	PINN	Pinnacles National Park	National Park	191683	1992
PW	CA	PINN	Pinnacles National Park	National Park	194757	1993
PW	CA	PINN	Pinnacles National Park	National Park	172642	1994
PW	CA	PINN	Pinnacles National Park	National Park	177527	1995
PW	CA	PINN	Pinnacles National Park	National Park	164465	1996
PW	CA	PINN	Pinnacles National Park	National Park	171971	1997
PW	CA	PINN	Pinnacles National Park	National Park	94639	1998
PW	CA	PINN	Pinnacles National Park	National Park	164854	1999
PW	CA	PINN	Pinnacles National Park	National Park	162110	2000
PW	CA	PINN	Pinnacles National Park	National Park	178243	2001
PW	CA	PINN	Pinnacles National Park	National Park	162266	2002
PW	CA	PINN	Pinnacles National Park	National Park	162791	2003
PW	CA	PINN	Pinnacles National Park	National Park	157397	2004
PW	CA	PINN	Pinnacles National Park	National Park	170994	2005
PW	CA	PINN	Pinnacles National Park	National Park	158824	2006
PW	CA	PINN	Pinnacles National Park	National Park	161019	2007
PW	CA	PINN	Pinnacles National Park	National Park	166988	2008
PW	CA	PINN	Pinnacles National Park	National Park	171112	2009
PW	CA	PINN	Pinnacles National Park	National Park	246575	2010
PW	CA	PINN	Pinnacles National Park	National Park	393219	2011
PW	CA	PINN	Pinnacles National Park	National Park	224476	2012
PW	CA	PINN	Pinnacles National Park	National Park	237677	2013
PW	CA	PINN	Pinnacles National Park	National Park	196635	2014
PW	CA	PINN	Pinnacles National Park	National Park	206533	2015
PW	CA	PINN	Pinnacles National Park	National Park	215555	2016
PW	CA	REDW	Redwood National Park	National Park	34500	1971
PW	CA	REDW	Redwood National Park	National Park	104304	1972
PW	CA	REDW	Redwood National Park	National Park	210500	1973
PW	CA	REDW	Redwood National Park	National Park	297400	1974
PW	CA	REDW	Redwood National Park	National Park	368200	1975
PW	CA	REDW	Redwood National Park	National Park	421700	1976
PW	CA	REDW	Redwood National Park	National Park	477900	1977
PW	CA	REDW	Redwood National Park	National Park	448012	1978
PW	CA	REDW	Redwood National Park	National Park	413917	1979
PW	CA	REDW	Redwood National Park	National Park	471710	1980
PW	CA	REDW	Redwood National Park	National Park	549461	1981
PW	CA	REDW	Redwood National Park	National Park	467126	1982
PW	CA	REDW	Redwood National Park	National Park	473711	1983
PW	CA	REDW	Redwood National Park	National Park	467155	1984
PW	CA	REDW	Redwood National Park	National Park	505791	1985
PW	CA	REDW	Redwood National Park	National Park	567849	1986
PW	CA	REDW	Redwood National Park	National Park	610897	1987
PW	CA	REDW	Redwood National Park	National Park	677135	1988
PW	CA	REDW	Redwood National Park	National Park	654115	1989
PW	CA	REDW	Redwood National Park	National Park	348458	1990
PW	CA	REDW	Redwood National Park	National Park	366280	1991
PW	CA	REDW	Redwood National Park	National Park	387781	1992
PW	CA	REDW	Redwood National Park	National Park	421027	1993
PW	CA	REDW	Redwood National Park	National Park	475033	1994
PW	CA	REDW	Redwood National Park	National Park	552464	1995
PW	CA	REDW	Redwood National Park	National Park	426938	1996
PW	CA	REDW	Redwood National Park	National Park	382488	1997
PW	CA	REDW	Redwood National Park	National Park	383188	1998
PW	CA	REDW	Redwood National Park	National Park	369726	1999
PW	CA	REDW	Redwood National Park	National Park	383253	2000
PW	CA	REDW	Redwood National Park	National Park	388352	2001
PW	CA	REDW	Redwood National Park	National Park	404789	2002
PW	CA	REDW	Redwood National Park	National Park	408126	2003
PW	CA	REDW	Redwood National Park	National Park	392029	2004
PW	CA	REDW	Redwood National Park	National Park	394144	2005
PW	CA	REDW	Redwood National Park	National Park	383780	2006
PW	CA	REDW	Redwood National Park	National Park	385171	2007
PW	CA	REDW	Redwood National Park	National Park	396899	2008
PW	CA	REDW	Redwood National Park	National Park	444426	2009
PW	CA	REDW	Redwood National Park	National Park	418820	2010
PW	CA	REDW	Redwood National Park	National Park	380167	2011
PW	CA	REDW	Redwood National Park	National Park	352517	2012
PW	CA	REDW	Redwood National Park	National Park	393364	2013
PW	CA	REDW	Redwood National Park	National Park	429166	2014
PW	CA	REDW	Redwood National Park	National Park	527143	2015
PW	CA	REDW	Redwood National Park	National Park	536297	2016
PW	CA	SEQU	Sequoia National Park	National Park	700	1906
PW	CA	SEQU	Sequoia National Park	National Park	900	1907
PW	CA	SEQU	Sequoia National Park	National Park	1251	1908
PW	CA	SEQU	Sequoia National Park	National Park	854	1909
PW	CA	SEQU	Sequoia National Park	National Park	2407	1910
PW	CA	SEQU	Sequoia National Park	National Park	3114	1911
PW	CA	SEQU	Sequoia National Park	National Park	2923	1912
PW	CA	SEQU	Sequoia National Park	National Park	3823	1913
PW	CA	SEQU	Sequoia National Park	National Park	4667	1914
PW	CA	SEQU	Sequoia National Park	National Park	7647	1915
PW	CA	SEQU	Sequoia National Park	National Park	10780	1916
PW	CA	SEQU	Sequoia National Park	National Park	18510	1917
PW	CA	SEQU	Sequoia National Park	National Park	15001	1918
PW	CA	SEQU	Sequoia National Park	National Park	30443	1919
PW	CA	SEQU	Sequoia National Park	National Park	31508	1920
PW	CA	SEQU	Sequoia National Park	National Park	28263	1921
PW	CA	SEQU	Sequoia National Park	National Park	27514	1922
PW	CA	SEQU	Sequoia National Park	National Park	30158	1923
PW	CA	SEQU	Sequoia National Park	National Park	34468	1924
PW	CA	SEQU	Sequoia National Park	National Park	46677	1925
PW	CA	SEQU	Sequoia National Park	National Park	89404	1926
PW	CA	SEQU	Sequoia National Park	National Park	100684	1927
PW	CA	SEQU	Sequoia National Park	National Park	98035	1928
PW	CA	SEQU	Sequoia National Park	National Park	111385	1929
PW	CA	SEQU	Sequoia National Park	National Park	129221	1930
PW	CA	SEQU	Sequoia National Park	National Park	143573	1931
PW	CA	SEQU	Sequoia National Park	National Park	131398	1932
PW	CA	SEQU	Sequoia National Park	National Park	126464	1933
PW	CA	SEQU	Sequoia National Park	National Park	147533	1934
PW	CA	SEQU	Sequoia National Park	National Park	205783	1935
PW	CA	SEQU	Sequoia National Park	National Park	230714	1936
PW	CA	SEQU	Sequoia National Park	National Park	243661	1937
PW	CA	SEQU	Sequoia National Park	National Park	260139	1938
PW	CA	SEQU	Sequoia National Park	National Park	275329	1939
PW	CA	SEQU	Sequoia National Park	National Park	282198	1940
PW	CA	SEQU	Sequoia National Park	National Park	302530	1941
PW	CA	SEQU	Sequoia National Park	National Park	154880	1942
PW	CA	SEQU	Sequoia National Park	National Park	62780	1943
PW	CA	SEQU	Sequoia National Park	National Park	54600	1944
PW	CA	SEQU	Sequoia National Park	National Park	137875	1945
PW	CA	SEQU	Sequoia National Park	National Park	315365	1946
PW	CA	SEQU	Sequoia National Park	National Park	373892	1947
PW	CA	SEQU	Sequoia National Park	National Park	403968	1948
PW	CA	SEQU	Sequoia National Park	National Park	367627	1949
PW	CA	SEQU	Sequoia National Park	National Park	379218	1950
PW	CA	SEQU	Sequoia National Park	National Park	452538	1951
PW	CA	SEQU	Sequoia National Park	National Park	472062	1952
PW	CA	SEQU	Sequoia National Park	National Park	501259	1953
PW	CA	SEQU	Sequoia National Park	National Park	484700	1954
PW	CA	SEQU	Sequoia National Park	National Park	518000	1955
PW	CA	SEQU	Sequoia National Park	National Park	538100	1956
PW	CA	SEQU	Sequoia National Park	National Park	535800	1957
PW	CA	SEQU	Sequoia National Park	National Park	512200	1958
PW	CA	SEQU	Sequoia National Park	National Park	547300	1959
PW	CA	SEQU	Sequoia National Park	National Park	610800	1960
PW	CA	SEQU	Sequoia National Park	National Park	610200	1961
PW	CA	SEQU	Sequoia National Park	National Park	687400	1962
PW	CA	SEQU	Sequoia National Park	National Park	631700	1963
PW	CA	SEQU	Sequoia National Park	National Park	654100	1964
PW	CA	SEQU	Sequoia National Park	National Park	877300	1965
PW	CA	SEQU	Sequoia National Park	National Park	797800	1966
PW	CA	SEQU	Sequoia National Park	National Park	746900	1967
PW	CA	SEQU	Sequoia National Park	National Park	874300	1968
PW	CA	SEQU	Sequoia National Park	National Park	919300	1969
PW	CA	SEQU	Sequoia National Park	National Park	875700	1970
PW	CA	SEQU	Sequoia National Park	National Park	878500	1971
PW	CA	SEQU	Sequoia National Park	National Park	867051	1972
PW	CA	SEQU	Sequoia National Park	National Park	845500	1973
PW	CA	SEQU	Sequoia National Park	National Park	686600	1974
PW	CA	SEQU	Sequoia National Park	National Park	957000	1975
PW	CA	SEQU	Sequoia National Park	National Park	1040600	1976
PW	CA	SEQU	Sequoia National Park	National Park	978200	1977
PW	CA	SEQU	Sequoia National Park	National Park	973056	1978
PW	CA	SEQU	Sequoia National Park	National Park	799576	1979
PW	CA	SEQU	Sequoia National Park	National Park	862397	1980
PW	CA	SEQU	Sequoia National Park	National Park	1083002	1981
PW	CA	SEQU	Sequoia National Park	National Park	1020500	1982
PW	CA	SEQU	Sequoia National Park	National Park	854233	1983
PW	CA	SEQU	Sequoia National Park	National Park	979632	1984
PW	CA	SEQU	Sequoia National Park	National Park	939468	1985
PW	CA	SEQU	Sequoia National Park	National Park	1056527	1986
PW	CA	SEQU	Sequoia National Park	National Park	1139389	1987
PW	CA	SEQU	Sequoia National Park	National Park	1031129	1988
PW	CA	SEQU	Sequoia National Park	National Park	1056020	1989
PW	CA	SEQU	Sequoia National Park	National Park	1063538	1990
PW	CA	SEQU	Sequoia National Park	National Park	1120278	1991
PW	CA	SEQU	Sequoia National Park	National Park	961095	1992
PW	CA	SEQU	Sequoia National Park	National Park	1066552	1993
PW	CA	SEQU	Sequoia National Park	National Park	1034133	1994
PW	CA	SEQU	Sequoia National Park	National Park	844582	1995
PW	CA	SEQU	Sequoia National Park	National Park	838060	1996
PW	CA	SEQU	Sequoia National Park	National Park	1008931	1997
PW	CA	SEQU	Sequoia National Park	National Park	861303	1998
PW	CA	SEQU	Sequoia National Park	National Park	873229	1999
PW	CA	SEQU	Sequoia National Park	National Park	838947	2000
PW	CA	SEQU	Sequoia National Park	National Park	870327	2001
PW	CA	SEQU	Sequoia National Park	National Park	920292	2002
PW	CA	SEQU	Sequoia National Park	National Park	979297	2003
PW	CA	SEQU	Sequoia National Park	National Park	1000177	2004
PW	CA	SEQU	Sequoia National Park	National Park	1004843	2005
PW	CA	SEQU	Sequoia National Park	National Park	954507	2006
PW	CA	SEQU	Sequoia National Park	National Park	979537	2007
PW	CA	SEQU	Sequoia National Park	National Park	930011	2008
PW	CA	SEQU	Sequoia National Park	National Park	965170	2009
PW	CA	SEQU	Sequoia National Park	National Park	1002979	2010
PW	CA	SEQU	Sequoia National Park	National Park	1006583	2011
PW	CA	SEQU	Sequoia National Park	National Park	1106584	2012
PW	CA	SEQU	Sequoia National Park	National Park	909274	2013
PW	CA	SEQU	Sequoia National Park	National Park	1039137	2014
PW	CA	SEQU	Sequoia National Park	National Park	1097464	2015
PW	CA	SEQU	Sequoia National Park	National Park	1254688	2016
PW	CA	YOSE	Yosemite National Park	National Park	5414	1906
PW	CA	YOSE	Yosemite National Park	National Park	7102	1907
PW	CA	YOSE	Yosemite National Park	National Park	8850	1908
PW	CA	YOSE	Yosemite National Park	National Park	13182	1909
PW	CA	YOSE	Yosemite National Park	National Park	13619	1910
PW	CA	YOSE	Yosemite National Park	National Park	12530	1911
PW	CA	YOSE	Yosemite National Park	National Park	10884	1912
PW	CA	YOSE	Yosemite National Park	National Park	13735	1913
PW	CA	YOSE	Yosemite National Park	National Park	15145	1914
PW	CA	YOSE	Yosemite National Park	National Park	33452	1915
PW	CA	YOSE	Yosemite National Park	National Park	33390	1916
PW	CA	YOSE	Yosemite National Park	National Park	34510	1917
PW	CA	YOSE	Yosemite National Park	National Park	33527	1918
PW	CA	YOSE	Yosemite National Park	National Park	58362	1919
PW	CA	YOSE	Yosemite National Park	National Park	68906	1920
PW	CA	YOSE	Yosemite National Park	National Park	91513	1921
PW	CA	YOSE	Yosemite National Park	National Park	100506	1922
PW	CA	YOSE	Yosemite National Park	National Park	130046	1923
PW	CA	YOSE	Yosemite National Park	National Park	105894	1924
PW	CA	YOSE	Yosemite National Park	National Park	209166	1925
PW	CA	YOSE	Yosemite National Park	National Park	274209	1926
PW	CA	YOSE	Yosemite National Park	National Park	490430	1927
PW	CA	YOSE	Yosemite National Park	National Park	460619	1928
PW	CA	YOSE	Yosemite National Park	National Park	461257	1929
PW	CA	YOSE	Yosemite National Park	National Park	458566	1930
PW	CA	YOSE	Yosemite National Park	National Park	461855	1931
PW	CA	YOSE	Yosemite National Park	National Park	498289	1932
PW	CA	YOSE	Yosemite National Park	National Park	296088	1933
PW	CA	YOSE	Yosemite National Park	National Park	309431	1934
PW	CA	YOSE	Yosemite National Park	National Park	372317	1935
PW	CA	YOSE	Yosemite National Park	National Park	431192	1936
PW	CA	YOSE	Yosemite National Park	National Park	481492	1937
PW	CA	YOSE	Yosemite National Park	National Park	443325	1938
PW	CA	YOSE	Yosemite National Park	National Park	466552	1939
PW	CA	YOSE	Yosemite National Park	National Park	506781	1940
PW	CA	YOSE	Yosemite National Park	National Park	597863	1941
PW	CA	YOSE	Yosemite National Park	National Park	319816	1942
PW	CA	YOSE	Yosemite National Park	National Park	116682	1943
PW	CA	YOSE	Yosemite National Park	National Park	120494	1944
PW	CA	YOSE	Yosemite National Park	National Park	290569	1945
PW	CA	YOSE	Yosemite National Park	National Park	640483	1946
PW	CA	YOSE	Yosemite National Park	National Park	777622	1947
PW	CA	YOSE	Yosemite National Park	National Park	745899	1948
PW	CA	YOSE	Yosemite National Park	National Park	808372	1949
PW	CA	YOSE	Yosemite National Park	National Park	820953	1950
PW	CA	YOSE	Yosemite National Park	National Park	858405	1951
PW	CA	YOSE	Yosemite National Park	National Park	973971	1952
PW	CA	YOSE	Yosemite National Park	National Park	969225	1953
PW	CA	YOSE	Yosemite National Park	National Park	1008000	1954
PW	CA	YOSE	Yosemite National Park	National Park	984200	1955
PW	CA	YOSE	Yosemite National Park	National Park	1114200	1956
PW	CA	YOSE	Yosemite National Park	National Park	1138700	1957
PW	CA	YOSE	Yosemite National Park	National Park	1139300	1958
PW	CA	YOSE	Yosemite National Park	National Park	1061500	1959
PW	CA	YOSE	Yosemite National Park	National Park	1150400	1960
PW	CA	YOSE	Yosemite National Park	National Park	1227100	1961
PW	CA	YOSE	Yosemite National Park	National Park	1505500	1962
PW	CA	YOSE	Yosemite National Park	National Park	1473400	1963
PW	CA	YOSE	Yosemite National Park	National Park	1547000	1964
PW	CA	YOSE	Yosemite National Park	National Park	1635400	1965
PW	CA	YOSE	Yosemite National Park	National Park	1817100	1966
PW	CA	YOSE	Yosemite National Park	National Park	2238300	1967
PW	CA	YOSE	Yosemite National Park	National Park	2281100	1968
PW	CA	YOSE	Yosemite National Park	National Park	2291300	1969
PW	CA	YOSE	Yosemite National Park	National Park	2277200	1970
PW	CA	YOSE	Yosemite National Park	National Park	2342200	1971
PW	CA	YOSE	Yosemite National Park	National Park	2190301	1972
PW	CA	YOSE	Yosemite National Park	National Park	2254300	1973
PW	CA	YOSE	Yosemite National Park	National Park	2274600	1974
PW	CA	YOSE	Yosemite National Park	National Park	2537400	1975
PW	CA	YOSE	Yosemite National Park	National Park	2682400	1976
PW	CA	YOSE	Yosemite National Park	National Park	2392600	1977
PW	CA	YOSE	Yosemite National Park	National Park	2569268	1978
PW	CA	YOSE	Yosemite National Park	National Park	2350782	1979
PW	CA	YOSE	Yosemite National Park	National Park	2490282	1980
PW	CA	YOSE	Yosemite National Park	National Park	2516893	1981
PW	CA	YOSE	Yosemite National Park	National Park	2415587	1982
PW	CA	YOSE	Yosemite National Park	National Park	2457464	1983
PW	CA	YOSE	Yosemite National Park	National Park	2738467	1984
PW	CA	YOSE	Yosemite National Park	National Park	2831952	1985
PW	CA	YOSE	Yosemite National Park	National Park	2876717	1986
PW	CA	YOSE	Yosemite National Park	National Park	3152275	1987
PW	CA	YOSE	Yosemite National Park	National Park	3216681	1988
PW	CA	YOSE	Yosemite National Park	National Park	3308159	1989
PW	CA	YOSE	Yosemite National Park	National Park	3124939	1990
PW	CA	YOSE	Yosemite National Park	National Park	3423101	1991
PW	CA	YOSE	Yosemite National Park	National Park	3819518	1992
PW	CA	YOSE	Yosemite National Park	National Park	3839645	1993
PW	CA	YOSE	Yosemite National Park	National Park	3962117	1994
PW	CA	YOSE	Yosemite National Park	National Park	3958406	1995
PW	CA	YOSE	Yosemite National Park	National Park	4046207	1996
PW	CA	YOSE	Yosemite National Park	National Park	3669970	1997
PW	CA	YOSE	Yosemite National Park	National Park	3657132	1998
PW	CA	YOSE	Yosemite National Park	National Park	3493607	1999
PW	CA	YOSE	Yosemite National Park	National Park	3400903	2000
PW	CA	YOSE	Yosemite National Park	National Park	3368731	2001
PW	CA	YOSE	Yosemite National Park	National Park	3361867	2002
PW	CA	YOSE	Yosemite National Park	National Park	3378664	2003
PW	CA	YOSE	Yosemite National Park	National Park	3280911	2004
PW	CA	YOSE	Yosemite National Park	National Park	3304144	2005
PW	CA	YOSE	Yosemite National Park	National Park	3242644	2006
PW	CA	YOSE	Yosemite National Park	National Park	3503428	2007
PW	CA	YOSE	Yosemite National Park	National Park	3431514	2008
PW	CA	YOSE	Yosemite National Park	National Park	3737472	2009
PW	CA	YOSE	Yosemite National Park	National Park	3901408	2010
PW	CA	YOSE	Yosemite National Park	National Park	3951393	2011
PW	CA	YOSE	Yosemite National Park	National Park	3853404	2012
PW	CA	YOSE	Yosemite National Park	National Park	3691191	2013
PW	CA	YOSE	Yosemite National Park	National Park	3882642	2014
PW	CA	YOSE	Yosemite National Park	National Park	4150217	2015
PW	CA	YOSE	Yosemite National Park	National Park	5028868	2016

Sparklines with gt

library(gt)
library(gtExtras)

ca_np |>
  dplyr::summarize(visitors_list = list(visitors),
                   .by = park_name) |>
  gt()

park_name	visitors_list
Channel Islands National Park	1200, 1500, 1600, 300, 15700, 31000, 33100, 32000, 24400, 31947, 44700, 31000, 74400, 92600, 87200, 46416, 82937, 104574, 87514, 172287, 205024, 203411, 164132, 172913, 174607, 168592, 152662, 144083, 149263, 169181, 184867, 175226, 525882, 490715, 488757, 574270, 607057, 482571, 520428, 613935, 585919, 537716, 434107, 375256, 360806, 332177, 348745, 277515, 242756, 249594, 212029, 342161, 324816, 364807
Death Valley National Park	9970, 19678, 42061, 40815, 48874, 58320, 61301, 80842, 100829, 44755, 14374, 13661, 31112, 100976, 161953, 162150, 208557, 189045, 219520, 296106, 338899, 337900, 342200, 300100, 333400, 334300, 335700, 355900, 397900, 363400, 408100, 403600, 453000, 437800, 476700, 469600, 458800, 580500, 290900, 293999, 315400, 368800, 545500, 582400, 620400, 673610, 631152, 618140, 630402, 679992, 635582, 621197, 576679, 586668, 665345, 692267, 664449, 690965, 743608, 869183, 998474, 971487, 1109421, 1189215, 1188212, 1177746, 1227583, 1179094, 1014636, 897596, 890375, 764820, 800113, 744440, 704122, 871938, 828574, 984775, 946867, 984568, 951972, 1101312, 1154843, 1296283
Joshua Tree National Park	31285, 23691, 17414, 7640, 18275, 36605, 57801, 59157, 66991, 79129, 93615, 141416, 172423, 260700, 280600, 312900, 320300, 365300, 299600, 320100, 301500, 331500, 346300, 343400, 336000, 408600, 416500, 489400, 550300, 643000, 576000, 602752, 589600, 509900, 552200, 728900, 745600, 602453, 590543, 545357, 612966, 673201, 671426, 663798, 641172, 783224, 830085, 955246, 990214, 1022396, 1145458, 1220539, 1252401, 1184871, 1235702, 1095046, 1226273, 1410312, 1316340, 1233935, 1280917, 1178376, 1283346, 1243659, 1375111, 1256421, 1298979, 1392446, 1304471, 1434976, 1396237, 1396117, 1383340, 1589904, 2025756, 2505286
Kings Canyon National Park	1000, 1000, 900, 1100, 1773, 798, 1178, 2160, 2240, 2756, 3735, 10523, 15360, 17390, 15496, 21574, 19661, 30312, 50456, 46230, 35020, 40517, 50597, 47996, 51988, 44783, 43547, 51995, 40806, 50081, 66024, 116739, 148568, 157810, 148116, 161080, 201545, 173587, 97745, 60651, 35203, 82442, 221990, 236687, 279231, 294021, 337840, 450031, 448156, 435548, 551500, 556100, 669800, 638500, 683900, 718500, 759800, 748600, 826100, 778600, 831600, 848900, 923400, 909900, 1064000, 946000, 1019000, 887000, 1051755, 899300, 1216800, 1031500, 1127900, 1041000, 864733, 804175, 819065, 776850, 831044, 765755, 937262, 874456, 1028785, 1081172, 1007695, 1037349, 1062867, 1071022, 637446, 636515, 725930, 832794, 502749, 484718, 540212, 559534, 528987, 541787, 545420, 555987, 525035, 594893, 552766, 580129, 574870, 609296, 598205, 566810, 591033, 567544, 502268, 468106, 607479
Lassen Volcanic National Park	8500, 2000, 2500, 2000, 10000, 10000, 9500, 12500, 12596, 18739, 20089, 26057, 26106, 31755, 56833, 41723, 45577, 51906, 52294, 76971, 86757, 73005, 100880, 104619, 109272, 48144, 18971, 19060, 45225, 99067, 149848, 160707, 172496, 183815, 203609, 212550, 225328, 282400, 304400, 303800, 327300, 346700, 379900, 401800, 460000, 399000, 369300, 407700, 400300, 462500, 358300, 442800, 435700, 466600, 447400, 504641, 496200, 408700, 444500, 461400, 381200, 442192, 380014, 394425, 415045, 414859, 429867, 463275, 451497, 439723, 472431, 495628, 466115, 460917, 463179, 468011, 434264, 385489, 351001, 351632, 391816, 318049, 353756, 374911, 376695, 388149, 404384, 379667, 365535, 388741, 395057, 377361, 365639, 384570, 351269, 407653, 427409, 432977, 468092, 536068
Pinnacles National Park	6500, 8973, 10000, 10167, 11265, 13216, 10756, 11862, 12813, 14238, 9957, 20129, 17872, 18614, 22426, 22266, 24717, 25068, 27131, 10311, 4570, 3845, 7494, 16298, 18328, 20331, 24557, 24814, 27090, 28236, 42199, 38300, 36500, 40300, 53200, 54900, 71400, 72000, 76900, 81500, 97000, 103200, 118000, 117900, 160600, 147000, 147000, 166200, 169200, 168896, 155500, 138500, 162200, 156900, 160500, 155822, 153717, 163626, 155205, 171026, 170631, 166258, 191578, 198236, 204705, 212094, 218601, 214268, 192610, 191683, 194757, 172642, 177527, 164465, 171971, 94639, 164854, 162110, 178243, 162266, 162791, 157397, 170994, 158824, 161019, 166988, 171112, 246575, 393219, 224476, 237677, 196635, 206533, 215555
Redwood National Park	34500, 104304, 210500, 297400, 368200, 421700, 477900, 448012, 413917, 471710, 549461, 467126, 473711, 467155, 505791, 567849, 610897, 677135, 654115, 348458, 366280, 387781, 421027, 475033, 552464, 426938, 382488, 383188, 369726, 383253, 388352, 404789, 408126, 392029, 394144, 383780, 385171, 396899, 444426, 418820, 380167, 352517, 393364, 429166, 527143, 536297
Sequoia National Park	700, 900, 1251, 854, 2407, 3114, 2923, 3823, 4667, 7647, 10780, 18510, 15001, 30443, 31508, 28263, 27514, 30158, 34468, 46677, 89404, 100684, 98035, 111385, 129221, 143573, 131398, 126464, 147533, 205783, 230714, 243661, 260139, 275329, 282198, 302530, 154880, 62780, 54600, 137875, 315365, 373892, 403968, 367627, 379218, 452538, 472062, 501259, 484700, 518000, 538100, 535800, 512200, 547300, 610800, 610200, 687400, 631700, 654100, 877300, 797800, 746900, 874300, 919300, 875700, 878500, 867051, 845500, 686600, 957000, 1040600, 978200, 973056, 799576, 862397, 1083002, 1020500, 854233, 979632, 939468, 1056527, 1139389, 1031129, 1056020, 1063538, 1120278, 961095, 1066552, 1034133, 844582, 838060, 1008931, 861303, 873229, 838947, 870327, 920292, 979297, 1000177, 1004843, 954507, 979537, 930011, 965170, 1002979, 1006583, 1106584, 909274, 1039137, 1097464, 1254688
Yosemite National Park	5414, 7102, 8850, 13182, 13619, 12530, 10884, 13735, 15145, 33452, 33390, 34510, 33527, 58362, 68906, 91513, 100506, 130046, 105894, 209166, 274209, 490430, 460619, 461257, 458566, 461855, 498289, 296088, 309431, 372317, 431192, 481492, 443325, 466552, 506781, 597863, 319816, 116682, 120494, 290569, 640483, 777622, 745899, 808372, 820953, 858405, 973971, 969225, 1008000, 984200, 1114200, 1138700, 1139300, 1061500, 1150400, 1227100, 1505500, 1473400, 1547000, 1635400, 1817100, 2238300, 2281100, 2291300, 2277200, 2342200, 2190301, 2254300, 2274600, 2537400, 2682400, 2392600, 2569268, 2350782, 2490282, 2516893, 2415587, 2457464, 2738467, 2831952, 2876717, 3152275, 3216681, 3308159, 3124939, 3423101, 3819518, 3839645, 3962117, 3958406, 4046207, 3669970, 3657132, 3493607, 3400903, 3368731, 3361867, 3378664, 3280911, 3304144, 3242644, 3503428, 3431514, 3737472, 3901408, 3951393, 3853404, 3691191, 3882642, 4150217, 5028868

Sparklines with gt

library(gt)
library(gtExtras)

ca_np |>
  dplyr::summarize(visitors_list = list(visitors),
                   .by = park_name) |>
  gt() |>
  gt_plt_sparkline(visitors_list)

park_name	visitors_list
Channel Islands National Park
Death Valley National Park
Joshua Tree National Park
Kings Canyon National Park
Lassen Volcanic National Park
Pinnacles National Park
Redwood National Park
Sequoia National Park
Yosemite National Park

REPT Charts

Seven essential Excel data visualization tips

Image bar chart
Geographical heat map
Color scales
Sparklines
REPT Charts
Data bars
Icon sets

REPT Charts

Also known as unit plots, dot plots, etc..

REPT Charts in ggplot2

library(ggplot2)

ggplot(data = airquality) +
  geom_dotplot(aes(x = Ozone),
               dotsize = .75, 
               stackratio = 1.2, 
               fill = "steelblue") +
  theme_minimal() +
  coord_flip()

REPT Charts in ggplot2

REPT Charts in gt

library(gt)
library(gtExtras)

gt(data = mtcars)

mpg	cyl	disp	hp	drat	wt	qsec	vs	am	gear	carb
21.0	6	160.0	110	3.90	2.620	16.46	0	1	4	4
21.0	6	160.0	110	3.90	2.875	17.02	0	1	4	4
22.8	4	108.0	93	3.85	2.320	18.61	1	1	4	1
21.4	6	258.0	110	3.08	3.215	19.44	1	0	3	1
18.7	8	360.0	175	3.15	3.440	17.02	0	0	3	2
18.1	6	225.0	105	2.76	3.460	20.22	1	0	3	1
14.3	8	360.0	245	3.21	3.570	15.84	0	0	3	4
24.4	4	146.7	62	3.69	3.190	20.00	1	0	4	2
22.8	4	140.8	95	3.92	3.150	22.90	1	0	4	2
19.2	6	167.6	123	3.92	3.440	18.30	1	0	4	4
17.8	6	167.6	123	3.92	3.440	18.90	1	0	4	4
16.4	8	275.8	180	3.07	4.070	17.40	0	0	3	3
17.3	8	275.8	180	3.07	3.730	17.60	0	0	3	3
15.2	8	275.8	180	3.07	3.780	18.00	0	0	3	3
10.4	8	472.0	205	2.93	5.250	17.98	0	0	3	4
10.4	8	460.0	215	3.00	5.424	17.82	0	0	3	4
14.7	8	440.0	230	3.23	5.345	17.42	0	0	3	4
32.4	4	78.7	66	4.08	2.200	19.47	1	1	4	1
30.4	4	75.7	52	4.93	1.615	18.52	1	1	4	2
33.9	4	71.1	65	4.22	1.835	19.90	1	1	4	1
21.5	4	120.1	97	3.70	2.465	20.01	1	0	3	1
15.5	8	318.0	150	2.76	3.520	16.87	0	0	3	2
15.2	8	304.0	150	3.15	3.435	17.30	0	0	3	2
13.3	8	350.0	245	3.73	3.840	15.41	0	0	3	4
19.2	8	400.0	175	3.08	3.845	17.05	0	0	3	2
27.3	4	79.0	66	4.08	1.935	18.90	1	1	4	1
26.0	4	120.3	91	4.43	2.140	16.70	0	1	5	2
30.4	4	95.1	113	3.77	1.513	16.90	1	1	5	2
15.8	8	351.0	264	4.22	3.170	14.50	0	1	5	4
19.7	6	145.0	175	3.62	2.770	15.50	0	1	5	6
15.0	8	301.0	335	3.54	3.570	14.60	0	1	5	8
21.4	4	121.0	109	4.11	2.780	18.60	1	1	4	2

REPT Charts in gt with gtExtras

library(gt)
library(gtExtras)

gt(data = mtcars) |> 
  gt_fa_repeats(column = cyl, 
                name = "square")

mpg	disp	hp	drat	wt	qsec	vs	am	gear	carb
21.0	160.0	110	3.90	2.620	16.46	0	1	4	4
21.0	160.0	110	3.90	2.875	17.02	0	1	4	4
22.8	108.0	93	3.85	2.320	18.61	1	1	4	1
21.4	258.0	110	3.08	3.215	19.44	1	0	3	1
18.7	360.0	175	3.15	3.440	17.02	0	0	3	2
18.1	225.0	105	2.76	3.460	20.22	1	0	3	1
14.3	360.0	245	3.21	3.570	15.84	0	0	3	4
24.4	146.7	62	3.69	3.190	20.00	1	0	4	2
22.8	140.8	95	3.92	3.150	22.90	1	0	4	2
19.2	167.6	123	3.92	3.440	18.30	1	0	4	4
17.8	167.6	123	3.92	3.440	18.90	1	0	4	4
16.4	275.8	180	3.07	4.070	17.40	0	0	3	3
17.3	275.8	180	3.07	3.730	17.60	0	0	3	3
15.2	275.8	180	3.07	3.780	18.00	0	0	3	3
10.4	472.0	205	2.93	5.250	17.98	0	0	3	4
10.4	460.0	215	3.00	5.424	17.82	0	0	3	4
14.7	440.0	230	3.23	5.345	17.42	0	0	3	4
32.4	78.7	66	4.08	2.200	19.47	1	1	4	1
30.4	75.7	52	4.93	1.615	18.52	1	1	4	2
33.9	71.1	65	4.22	1.835	19.90	1	1	4	1
21.5	120.1	97	3.70	2.465	20.01	1	0	3	1
15.5	318.0	150	2.76	3.520	16.87	0	0	3	2
15.2	304.0	150	3.15	3.435	17.30	0	0	3	2
13.3	350.0	245	3.73	3.840	15.41	0	0	3	4
19.2	400.0	175	3.08	3.845	17.05	0	0	3	2
27.3	79.0	66	4.08	1.935	18.90	1	1	4	1
26.0	120.3	91	4.43	2.140	16.70	0	1	5	2
30.4	95.1	113	3.77	1.513	16.90	1	1	5	2
15.8	351.0	264	4.22	3.170	14.50	0	1	5	4
19.7	145.0	175	3.62	2.770	15.50	0	1	5	6
15.0	301.0	335	3.54	3.570	14.60	0	1	5	8
21.4	121.0	109	4.11	2.780	18.60	1	1	4	2

REPT Charts in gt with gtExtras

library(gt)
library(gtExtras)

gt(data = mtcars) |> 
  gt_fa_repeats(column = cyl,
                name = "car")

mpg	disp	hp	drat	wt	qsec	vs	am	gear	carb
21.0	160.0	110	3.90	2.620	16.46	0	1	4	4
21.0	160.0	110	3.90	2.875	17.02	0	1	4	4
22.8	108.0	93	3.85	2.320	18.61	1	1	4	1
21.4	258.0	110	3.08	3.215	19.44	1	0	3	1
18.7	360.0	175	3.15	3.440	17.02	0	0	3	2
18.1	225.0	105	2.76	3.460	20.22	1	0	3	1
14.3	360.0	245	3.21	3.570	15.84	0	0	3	4
24.4	146.7	62	3.69	3.190	20.00	1	0	4	2
22.8	140.8	95	3.92	3.150	22.90	1	0	4	2
19.2	167.6	123	3.92	3.440	18.30	1	0	4	4
17.8	167.6	123	3.92	3.440	18.90	1	0	4	4
16.4	275.8	180	3.07	4.070	17.40	0	0	3	3
17.3	275.8	180	3.07	3.730	17.60	0	0	3	3
15.2	275.8	180	3.07	3.780	18.00	0	0	3	3
10.4	472.0	205	2.93	5.250	17.98	0	0	3	4
10.4	460.0	215	3.00	5.424	17.82	0	0	3	4
14.7	440.0	230	3.23	5.345	17.42	0	0	3	4
32.4	78.7	66	4.08	2.200	19.47	1	1	4	1
30.4	75.7	52	4.93	1.615	18.52	1	1	4	2
33.9	71.1	65	4.22	1.835	19.90	1	1	4	1
21.5	120.1	97	3.70	2.465	20.01	1	0	3	1
15.5	318.0	150	2.76	3.520	16.87	0	0	3	2
15.2	304.0	150	3.15	3.435	17.30	0	0	3	2
13.3	350.0	245	3.73	3.840	15.41	0	0	3	4
19.2	400.0	175	3.08	3.845	17.05	0	0	3	2
27.3	79.0	66	4.08	1.935	18.90	1	1	4	1
26.0	120.3	91	4.43	2.140	16.70	0	1	5	2
30.4	95.1	113	3.77	1.513	16.90	1	1	5	2
15.8	351.0	264	4.22	3.170	14.50	0	1	5	4
19.7	145.0	175	3.62	2.770	15.50	0	1	5	6
15.0	301.0	335	3.54	3.570	14.60	0	1	5	8
21.4	121.0	109	4.11	2.780	18.60	1	1	4	2

Data bars

Seven essential Excel data visualization tips

Image bar chart
Geographical heat map
Color scales
Sparklines
REPT Charts
Data bars
Icon sets

Data bars

Data bars in ggplot2

library(ggplot2)

ggplot(data = mtcars) +
  geom_bar(aes(x = cyl,
               fill = as.factor(cyl)),
           color = "black") +
  theme(legend.position = "none") + 
  labs(title = "ggplot fill")

Data bars in ggplot2

library(ggplot2)

ggplot(data = mtcars) +
  geom_bar(aes(x = cyl,
               fill = as.factor(cyl)),
           color = "black") +
  theme(legend.position = "none") + 
  labs(title = "ggplot fill") +
  coord_flip()

Data bars in ggplot2

library(ggplot2)

ggplot(data = mtcars) +
  geom_bar(aes(x = cyl,
               fill = as.factor(cyl)),
           color = "black") +
  theme(legend.position = "none") +
  labs(title = "ggplot fill") +
  coord_flip() +
  geom_text(
    stat = "count",
    aes(x = cyl, y = after_stat(count), 
        label = after_stat(count)),
    hjust = 1.3,
    color = "black",
    size = 8)

Data bars in ggplot2

Data bars in gt with gtExtras

mtcars |> 
  gt() |> 
  gt_fa_repeats(cyl, name = "car")

mpg	disp	hp	drat	wt	qsec	vs	am	gear	carb
21.0	160.0	110	3.90	2.620	16.46	0	1	4	4
21.0	160.0	110	3.90	2.875	17.02	0	1	4	4
22.8	108.0	93	3.85	2.320	18.61	1	1	4	1
21.4	258.0	110	3.08	3.215	19.44	1	0	3	1
18.7	360.0	175	3.15	3.440	17.02	0	0	3	2
18.1	225.0	105	2.76	3.460	20.22	1	0	3	1
14.3	360.0	245	3.21	3.570	15.84	0	0	3	4
24.4	146.7	62	3.69	3.190	20.00	1	0	4	2
22.8	140.8	95	3.92	3.150	22.90	1	0	4	2
19.2	167.6	123	3.92	3.440	18.30	1	0	4	4
17.8	167.6	123	3.92	3.440	18.90	1	0	4	4
16.4	275.8	180	3.07	4.070	17.40	0	0	3	3
17.3	275.8	180	3.07	3.730	17.60	0	0	3	3
15.2	275.8	180	3.07	3.780	18.00	0	0	3	3
10.4	472.0	205	2.93	5.250	17.98	0	0	3	4
10.4	460.0	215	3.00	5.424	17.82	0	0	3	4
14.7	440.0	230	3.23	5.345	17.42	0	0	3	4
32.4	78.7	66	4.08	2.200	19.47	1	1	4	1
30.4	75.7	52	4.93	1.615	18.52	1	1	4	2
33.9	71.1	65	4.22	1.835	19.90	1	1	4	1
21.5	120.1	97	3.70	2.465	20.01	1	0	3	1
15.5	318.0	150	2.76	3.520	16.87	0	0	3	2
15.2	304.0	150	3.15	3.435	17.30	0	0	3	2
13.3	350.0	245	3.73	3.840	15.41	0	0	3	4
19.2	400.0	175	3.08	3.845	17.05	0	0	3	2
27.3	79.0	66	4.08	1.935	18.90	1	1	4	1
26.0	120.3	91	4.43	2.140	16.70	0	1	5	2
30.4	95.1	113	3.77	1.513	16.90	1	1	5	2
15.8	351.0	264	4.22	3.170	14.50	0	1	5	4
19.7	145.0	175	3.62	2.770	15.50	0	1	5	6
15.0	301.0	335	3.54	3.570	14.60	0	1	5	8
21.4	121.0	109	4.11	2.780	18.60	1	1	4	2

Data bars in gt with gtExtras

mtcars |> 
  gt() |> 
  gt_fa_repeats(cyl, name = "car") |> 
  gt_plt_bar(column = disp)

mpg	hp	drat	wt	qsec	vs	am	gear	carb
21.0	110	3.90	2.620	16.46	0	1	4	4
21.0	110	3.90	2.875	17.02	0	1	4	4
22.8	93	3.85	2.320	18.61	1	1	4	1
21.4	110	3.08	3.215	19.44	1	0	3	1
18.7	175	3.15	3.440	17.02	0	0	3	2
18.1	105	2.76	3.460	20.22	1	0	3	1
14.3	245	3.21	3.570	15.84	0	0	3	4
24.4	62	3.69	3.190	20.00	1	0	4	2
22.8	95	3.92	3.150	22.90	1	0	4	2
19.2	123	3.92	3.440	18.30	1	0	4	4
17.8	123	3.92	3.440	18.90	1	0	4	4
16.4	180	3.07	4.070	17.40	0	0	3	3
17.3	180	3.07	3.730	17.60	0	0	3	3
15.2	180	3.07	3.780	18.00	0	0	3	3
10.4	205	2.93	5.250	17.98	0	0	3	4
10.4	215	3.00	5.424	17.82	0	0	3	4
14.7	230	3.23	5.345	17.42	0	0	3	4
32.4	66	4.08	2.200	19.47	1	1	4	1
30.4	52	4.93	1.615	18.52	1	1	4	2
33.9	65	4.22	1.835	19.90	1	1	4	1
21.5	97	3.70	2.465	20.01	1	0	3	1
15.5	150	2.76	3.520	16.87	0	0	3	2
15.2	150	3.15	3.435	17.30	0	0	3	2
13.3	245	3.73	3.840	15.41	0	0	3	4
19.2	175	3.08	3.845	17.05	0	0	3	2
27.3	66	4.08	1.935	18.90	1	1	4	1
26.0	91	4.43	2.140	16.70	0	1	5	2
30.4	113	3.77	1.513	16.90	1	1	5	2
15.8	264	4.22	3.170	14.50	0	1	5	4
19.7	175	3.62	2.770	15.50	0	1	5	6
15.0	335	3.54	3.570	14.60	0	1	5	8
21.4	109	4.11	2.780	18.60	1	1	4	2

Data bars in gt with gtExtras

mtcars |> 
  gt() |> 
  gt_fa_repeats(cyl, name = "car") |> 
  gt_plt_bar(column = disp,
             color = "#871C0F",
             scale_type = "number") |> 
  gt_plt_bar(column = hp,
             color = "#028BA8",
             scale_type = "number") |> 
  gt_plt_bar(column = drat,
             color = "#244E57",
             scale_type = "number")

Data bars in gt with gtExtras

mpg	wt	qsec	vs	am	gear	carb
21.0	2.620	16.46	0	1	4	4
21.0	2.875	17.02	0	1	4	4
22.8	2.320	18.61	1	1	4	1
21.4	3.215	19.44	1	0	3	1
18.7	3.440	17.02	0	0	3	2
18.1	3.460	20.22	1	0	3	1
14.3	3.570	15.84	0	0	3	4
24.4	3.190	20.00	1	0	4	2
22.8	3.150	22.90	1	0	4	2
19.2	3.440	18.30	1	0	4	4
17.8	3.440	18.90	1	0	4	4
16.4	4.070	17.40	0	0	3	3
17.3	3.730	17.60	0	0	3	3
15.2	3.780	18.00	0	0	3	3
10.4	5.250	17.98	0	0	3	4
10.4	5.424	17.82	0	0	3	4
14.7	5.345	17.42	0	0	3	4
32.4	2.200	19.47	1	1	4	1
30.4	1.615	18.52	1	1	4	2
33.9	1.835	19.90	1	1	4	1
21.5	2.465	20.01	1	0	3	1
15.5	3.520	16.87	0	0	3	2
15.2	3.435	17.30	0	0	3	2
13.3	3.840	15.41	0	0	3	4
19.2	3.845	17.05	0	0	3	2
27.3	1.935	18.90	1	1	4	1
26.0	2.140	16.70	0	1	5	2
30.4	1.513	16.90	1	1	5	2
15.8	3.170	14.50	0	1	5	4
19.7	2.770	15.50	0	1	5	6
15.0	3.570	14.60	0	1	5	8
21.4	2.780	18.60	1	1	4	2

Icon sets

Seven essential Excel data visualization tips

Image bar chart
Geographical heat map
Color scales
Sparklines
REPT Charts
Data bars
Icon sets

Icon sets

mtcars |> 
  gt() |> 
  gt_fa_repeats(cyl, name = "car") |> 
  gt_plt_bar(column = disp) |> 
  gt_fa_rank_change(column = disp,
                    fa_type = "arrow")

mpg	disp	hp	drat	wt	qsec	vs	am	gear	carb
21.0	160	110	3.90	2.620	16.46	0	1	4	4
21.0	160	110	3.90	2.875	17.02	0	1	4	4
22.8	108	93	3.85	2.320	18.61	1	1	4	1
21.4	258	110	3.08	3.215	19.44	1	0	3	1
18.7	360	175	3.15	3.440	17.02	0	0	3	2
18.1	225	105	2.76	3.460	20.22	1	0	3	1
14.3	360	245	3.21	3.570	15.84	0	0	3	4
24.4	146.7	62	3.69	3.190	20.00	1	0	4	2
22.8	140.8	95	3.92	3.150	22.90	1	0	4	2
19.2	167.6	123	3.92	3.440	18.30	1	0	4	4
17.8	167.6	123	3.92	3.440	18.90	1	0	4	4
16.4	275.8	180	3.07	4.070	17.40	0	0	3	3
17.3	275.8	180	3.07	3.730	17.60	0	0	3	3
15.2	275.8	180	3.07	3.780	18.00	0	0	3	3
10.4	472	205	2.93	5.250	17.98	0	0	3	4
10.4	460	215	3.00	5.424	17.82	0	0	3	4
14.7	440	230	3.23	5.345	17.42	0	0	3	4
32.4	78.7	66	4.08	2.200	19.47	1	1	4	1
30.4	75.7	52	4.93	1.615	18.52	1	1	4	2
33.9	71.1	65	4.22	1.835	19.90	1	1	4	1
21.5	120.1	97	3.70	2.465	20.01	1	0	3	1
15.5	318	150	2.76	3.520	16.87	0	0	3	2
15.2	304	150	3.15	3.435	17.30	0	0	3	2
13.3	350	245	3.73	3.840	15.41	0	0	3	4
19.2	400	175	3.08	3.845	17.05	0	0	3	2
27.3	79	66	4.08	1.935	18.90	1	1	4	1
26.0	120.3	91	4.43	2.140	16.70	0	1	5	2
30.4	95.1	113	3.77	1.513	16.90	1	1	5	2
15.8	351	264	4.22	3.170	14.50	0	1	5	4
19.7	145	175	3.62	2.770	15.50	0	1	5	6
15.0	301	335	3.54	3.570	14.60	0	1	5	8
21.4	121	109	4.11	2.780	18.60	1	1	4	2

Wrapping up

Geographical heat map
Image bar chart
Color scales
Sparklines
REPT charts
Data bars
Icon sets

Installing required packages

To run the code in this presentation, please run the following code:

if (!require("pak")) install.packages("pak")
pak::pkg_install("tidyverse", "ggpattern", "gt", "gtExtras", "maps")

Create plots with esquiesse

Save output

ggplot2

ggsave(
  filename,
  plot = last_plot(),
  device = NULL,
  path = NULL,
  scale = 1,
  width = NA,
  height = NA,
  units = c("in", "cm", "mm", "px"),
  dpi = 300,
  limitsize = TRUE,
  bg = NULL,
  ...
)

Save output

gt

as_word(
  data,
  align = "center",
  caption_location = c("top", "bottom", "embed"),
  caption_align = "left",
  split = FALSE,
  keep_with_next = TRUE
)

Resources

Learning R as an Excel user

World maps

Geeks for Geeks: How to make a world map with R

Resources

Heatmaps

Jānis Stūris: How to create a simple heatmap in R

Styling gt