Archives

Income Volatility Line Graphs

Bradley Hardy from American University sends in the following request: I’m trying to figure out how to create “nice” panel charts in excel, where I’m currently attempting to do so in Stata. (See for example Figure 2.) I can easily…

Continue reading

Trying to Fix “The Fix”

Over on PolicyViz, I wrote a post about this graph from The Fix at the Washington Post. I’m not a fan of the graph namely because the focus of the article was about the change in approval ratings between 2012…

Continue reading

Part-to-Whole Help

Reader and contributor Ulrik Willemoes writes in the following request for Excel help. I am looking for some feedback on a rather basic visualization. I wish to display a parts-to-whole relationship over time. I know stacked bars or areas do not…

Continue reading

Trajectories of Obesity

This request comes from Joyce Lee at the University of Michigan. I published this paper long ago on trends in obesity over people’s lives. The images from that paper can be found in this PPT file (the data is embedded in…

Continue reading

Charting Player Impact vs Time on Court

Over on PolicyViz.com, Mynda Treacy from MyOnlineTrainingHub wrote a guest blog post about visualizing basketball data. Mynda writes about and teaches Excel skills, ranging from number formats to chart types to VBA code. In her PolicyViz post, Mynda walks through her…

Continue reading

Visualizing YouTube Analytics

Hi! My name is Julie, and I need help visualizing some YouTube channel analytics data over time. Attached is the spreadsheet I’m working on as well as quick mock-up in Paint of what I’d like the graph to look like. On…

Continue reading

Trying to Excel at Excel

I am trying to create an Excel column chart that displays a ‘Target’ column and an ‘Actual’ column by month. I would like the ‘Target’ column to always show on the chart in blue and next to it (right) I…

Continue reading

Have Data, Will Visualize

This submission is a first for HelpMeViz. A foundation sent in their data and need help visualizing the data. Have fun. This spreadsheet summarizes the 300 grants awarded by our foundation in the past year. It includes the type of grant…

Continue reading
Close