Seven essential Excel data visualization tips

Introduction

@ivelasq

@ivelasq3

@ivelasq3

ivelasq.rbind.io

Inspiration for this talk

Another inspiration for this talk

Another inspiration for this talk

One more inspiration

Art by Allison Horst

Seven essential Excel data visualization tips

  1. Image bar chart

Seven essential Excel data visualization tips

  1. Image bar chart
  2. Geographical heat map

Seven essential Excel data visualization tips

  1. Image bar chart
  2. Geographical heat map
  3. Color scales

Seven essential Excel data visualization tips

  1. Image bar chart
  2. Geographical heat map
  3. Color scales
  4. Sparklines

Seven essential Excel data visualization tips

  1. Image bar chart
  2. Geographical heat map
  3. Color scales
  4. Sparklines
  5. REPT charts

Seven essential Excel data visualization tips

  1. Image bar chart
  2. Geographical heat map
  3. Color scales
  4. Sparklines
  5. REPT charts
  6. Data bars

Seven essential Excel data visualization tips

  1. Image bar chart
  2. Geographical heat map
  3. Color scales
  4. Sparklines
  5. REPT charts
  6. Data bars
  7. 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")
Channel Islands NP Visitation
Annual park visitors
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") |>
  fmt_number(columns = visitors,
             decimals = 0,
             use_seps = TRUE)
Channel Islands NP Visitation
Annual park visitors
region state code park_name type visitors year
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)
Channel Islands NP Visitation
Annual park visitors
region state code park_name type visitors year
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

  1. Image bar chart

  2. Geographical heat map

  3. Color scales

  4. Sparklines

  5. REPT Charts

  6. Data bars

  7. 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

  1. Image bar chart

  2. Geographical heat map

  3. Color scales

  4. Sparklines

  5. REPT Charts

  6. Data bars

  7. 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

  1. Image bar chart

  2. Geographical heat map

  3. Color scales

  4. Sparklines

  5. REPT Charts

  6. Data bars

  7. 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)")
United States Personal Expenditures
(in billions of dollars)
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

Sparklines

Seven essential Excel data visualization tips

  1. Image bar chart

  2. Geographical heat map

  3. Color scales

  4. Sparklines

  5. REPT Charts

  6. Data bars

  7. 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 364.8K
Death Valley National Park 1.3M
Joshua Tree National Park 2.5M
Kings Canyon National Park 607.5K
Lassen Volcanic National Park 536.1K
Pinnacles National Park 215.6K
Redwood National Park 536.3K
Sequoia National Park 1.3M
Yosemite National Park 5.0M

REPT Charts

Seven essential Excel data visualization tips

  1. Image bar chart

  2. Geographical heat map

  3. Color scales

  4. Sparklines

  5. REPT Charts

  6. Data bars

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

Data bars

Seven essential Excel data visualization tips

  1. Image bar chart

  2. Geographical heat map

  3. Color scales

  4. Sparklines

  5. REPT Charts

  6. Data bars

  7. 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 cyl disp hp drat wt qsec vs am gear carb
21.0
Car Car Car Car Car Car
160.0 110 3.90 2.620 16.46 0 1 4 4
21.0
Car Car Car Car Car Car
160.0 110 3.90 2.875 17.02 0 1 4 4
22.8
Car Car Car Car
108.0 93 3.85 2.320 18.61 1 1 4 1
21.4
Car Car Car Car Car Car
258.0 110 3.08 3.215 19.44 1 0 3 1
18.7
Car Car Car Car Car Car Car Car
360.0 175 3.15 3.440 17.02 0 0 3 2
18.1
Car Car Car Car Car Car
225.0 105 2.76 3.460 20.22 1 0 3 1
14.3
Car Car Car Car Car Car Car Car
360.0 245 3.21 3.570 15.84 0 0 3 4
24.4
Car Car Car Car
146.7 62 3.69 3.190 20.00 1 0 4 2
22.8
Car Car Car Car
140.8 95 3.92 3.150 22.90 1 0 4 2
19.2
Car Car Car Car Car Car
167.6 123 3.92 3.440 18.30 1 0 4 4
17.8
Car Car Car Car Car Car
167.6 123 3.92 3.440 18.90 1 0 4 4
16.4
Car Car Car Car Car Car Car Car
275.8 180 3.07 4.070 17.40 0 0 3 3
17.3
Car Car Car Car Car Car Car Car
275.8 180 3.07 3.730 17.60 0 0 3 3
15.2
Car Car Car Car Car Car Car Car
275.8 180 3.07 3.780 18.00 0 0 3 3
10.4
Car Car Car Car Car Car Car Car
472.0 205 2.93 5.250 17.98 0 0 3 4
10.4
Car Car Car Car Car Car Car Car
460.0 215 3.00 5.424 17.82 0 0 3 4
14.7
Car Car Car Car Car Car Car Car
440.0 230 3.23 5.345 17.42 0 0 3 4
32.4
Car Car Car Car
78.7 66 4.08 2.200 19.47 1 1 4 1
30.4
Car Car Car Car
75.7 52 4.93 1.615 18.52 1 1 4 2
33.9
Car Car Car