Web Analytics
Story Structure Policy Viz PolicyViz t Story structure

Story Structure Policy Viz PolicyViz t Story structure

<

Back in January, Nathan Yau at Flowing Data published an interactive set of waffle charts that allows you to explore selected demographics of people in the ...

To get the other Waffle charts set up, you need to copy-and-paste the IF statement, but you also need to do some manual work and change the $B$4 reference ...

Waffle Chart Schematic (blue). This is essentially the waffle chart, here placing the positions of each cell in the grid.

The WafflesSetUp worksheet is going to contain the raw data and all the lookup tables I'll need to make this work. I'll explain all the details about that ...

Okay, let's go back up to the DropDown Table (orange) at the top. Column B is where we find the data that matches the series the user wants to find and will ...

Visualizing Bad Feedback

I'll create three dropdown menus in this same way and then merge and format the cells. This will make the button labels big enough to see and centered ...

I'll create three dropdown menus in this same way and then merge and format the cells. This will make the button labels big enough to see and centered ...

Note: An alternative way to do this would be to change the IF statement for each chart so that the numbers are different in each one (e.g., the formula in ...

Data Lookup Tables (purple). I'm going to need this because the category labels in the original data set were numbers, not text (strings), so I'll use this ...

Menu Labels (gray). As noted above, I use these to populate the Data Validation button in the Waffles tab.

Using Excel VBA to Improve Workflow

Plotting Multiple Groups and Multiple Series

Part-to-Whole Help

Narration consists of guiding the reader through your visualizations as a sequence (this can be accomplished across multiple charts or panels).

I'm going to need this because the category labels in the original data set were numbers, not text (strings), so I'll use this as a lookup table to create ...

DropDown Table (orange). Column B contains the selected data series; in the screenshot, you can see that the user has selected “Females, 18-to-24, White”, ...

On Stories at PolicyViz

It works just the same as the other VLOOKUP statements, but looks to the last column of the full data set that has the sample counts.

Trajectories of Obesity

I also did a version in which I sorted the series by the last value (2012).

Maps – At a Loss

Combination Chart

Now, instead of adding lines, I'll add a series of scatterplot points that will be positioned at the top-right corner of each bar.

People who work with and communicate data tend to throw around the words “ story” and “data” a lot these days. We say all too regularly, “Let's tell a story ...

control chart

With the points positioned on the top-right corner of each column, horizontal error bars are added to extend to the next column.

Blog

A Pie Chart Triplet as a Parallel Coordinates Plot?

The length of each error bar is set to 0.6 and are formatted to have an arrow head at the end position (I couldn't tell you exactly why 0.6 works, but, ...

Trying to Excel at Excel

Help finding the right tool

This was the question posed to a group of 15 academic researchers across several social science fields at a recent conference I attended.

The post The Graphic Continuum Match It Game appeared first on Policy Viz.

The length of each error bar is set to 0.6 and are formatted to have an arrow head at the end position (I couldn't tell you exactly why 0.6 works, but, ...

Graphic Continuum Poster Giveaway - Policy Viz

I set up the data in a different worksheet and start by sorting each separately (columns A, F, and L). (Again, if I had more data, I would probably do this ...

... don't help direct your eye anywhere on the page. The table might also benefit from some ways to offset the column headers and some of the row headers.

Paint By Numbers: A Rough Guide to Tableau Dashboard Actions

Dear Data: Business School Edition, Vol. II

Dear Data: Business School Edition - Policy Viz

Story Structure - Policy Viz | PolicyViz | Pinterest | Traditional stories and Writers write

The post The Graphic Continuum Match It Game appeared first on Policy Viz.

Story Structure - Policy Viz | PolicyViz | Pinterest | Traditional stories and Writers write

Better Presentations: A Guide for Scholars, Researchers, and Wonks will help presenters of scholarly or data-intensive content improve their presentations.

Mapping Program Participation by State

Have Data, Will Visualize

The post The Graphic Continuum Match It Game appeared first on Policy Viz.

Story Structure - Policy Viz | PolicyViz | Pinterest | Traditional stories and Writers write

Story Structure - Policy Viz | PolicyViz | Pinterest | Traditional stories and Writers write

Story Structure - Policy Viz | PolicyViz | Pinterest | Traditional stories and Writers write

Story Structure - Policy Viz | PolicyViz | Pinterest | Traditional stories and Writers write

News

Lupi data viz

Malofiej 25 Awards

It may be because many people simply don't understand statistics and distributions, nor do they understand the mathematical concept ...

3 Ways to Preserve 'Percent of Total' within Filtered Dimensions

9.

On Stories at PolicyViz · The brand new PolicyViz Podcast tshirt!

Tableau Resources/Examples (Univ of Buffalo)

... 13.

8 best Data visualization ideas images on Pinterest | Info graphics, Information visualization and Data visualisation

image24

Story Structure - Policy Viz | PolicyViz | Pinterest | Traditional stories and Writers write

PowerPoint Shortcuts Card Policy Viz

Illustrations on the difference between the U.S. and Great Britain by the Isotype Institute [17

Nussbaumer data viz

The Atlantic Coastal Conference - Rody Zakovich | Tableau Public

More Story References and Resources

Story Structure - Policy Viz | PolicyViz | Pinterest | Traditional stories and Writers write

8 best Data visualization ideas images on Pinterest | Info graphics, Information visualization and Data visualisation

Tableau Factbook

Dot Plot of different Gini coefficients, variation on graph from Max Roser

Exporting CSV made simple!

Sir Viz-a-Lot

12.

Schwabish data viz

About td-net's toolbox for co-producing knowledge - Co-producing Knowledge

NodeXL

Institutional Research Resources (AIR)

5.

Story Structure - Policy Viz | PolicyViz | Pinterest | Traditional stories and Writers write

2014 ~ Data Viz Done Right

#writingadvice @writingtip

Applying Data to Story Structure - Policy Viz

As the terms “story” and “data” get mixed together more and more · Traditional StoriesStory StructureWriting ...

Comparing time use survey data (bottom) with a focus on travel activities (dark

A more complex visualisation of all air pollution measured by sensors in London, organized in

It's (almost) Fall – a good time for telling stories! Jon Schwabish invited me to be on his PolicyViz podcast again to kick off its new season.

Data Wrapper - an open source tool enabling quick and easy chart creation and embedding. To try out! | Journalism tools | Pinterest | Chart, Open source and ...

nolangaskill on

Happy Pi Day!

Data Wrapper - an open source tool enabling quick and easy chart creation and embedding. To try out! | Journalism tools | Pinterest | Chart, Open source and ...

... Data project, which studies how ...

11.

Find this Pin and more on Tips / Info by allanchan819.

Left: applying KNN with K=1 and K=4; right: applying