Reddit AMA count visualization – Under 15 mins

Share on facebook
Share on twitter
Share on linkedin
Share on reddit
Share on email

Someone on Reddit posted a summary of counts of AMA by category.

The counts are shown in this thread

Image

Let us see how quickly we can visualize this data?

Step1 : We copy the data and paste into Excel

Inside the browser, we select the text, right click and copy the text

Image

We then paste the data into Excel

Step2: Split the single column into two columns

Image

In the text to columns wizard we give the “:” colon as the seperator

Image

 

Step 3: Copy the columns and Transpose

Image

 

Copy the contents of the two columns

Next, select another cell on the same sheet, right click and select “Paste Special”

Image

 

Image

 

Select ‘Transpose’ in the paste special options. Click OK

Image

 

In the last cell just, create a formula to concatenate all the values into a single cell

=H1&”,”&I1&”,”&J1&”,”&K1&”,”&L1&”,”&M1&”,”&N1&”,”&O1&”,”&P1&”,”&Q1&”,”&R1&”,”&S1&”,”&T1&”,”&U1&”,”&V1

Image

 

Copy the formula and paste it for the below row too. Now we have all the data in two cells

Login to InfoCaptor Dashboard

Create a New page and drag the Pie chart

Image

 

Right click on the chart and select ‘Edit Text’

Image

 

Paste the Excel data here

Image

 

Prefix the first line with “lables:” and the next line with appropriate data name, in this case “Reddit AMA:” (see below)

Image

 

Important: When you copy/paste from Excel, it adds blank lines. Make sure you delete any extra lines. The sure way to know that there are no blank lines is that the cursor does not go to the next line when you press down arrow.

Here is the final chart

Image

The chart took under 15 mins from data scraping, excel merge to the final presentation but this tutorial took around 60 mins to prepare 🙂

Reddit AMA Visualization – Pie and Bar chart comparison

Custom Reports and Dashboards

We will build you a set of custom reports and dashboards
Best Offer

The Core Tools

Create dashboard for any Database

Data Visualizer and Dashboard Application
SALE
This is the best dashboard software for its price. One good thing we did was to hire their consulting services to build few dashboard prototypes and provide some quick dashboard training.
- Terry Seal, IL
We evaluated Xcelsius and Qlikview and the cost for organization to implement dashboards was quoted over 10,000 USD. For fraction of the above quoted price, we were able to buy the licenses for the web based dashboard software and get some free training. This is truly a dashboard software for small businesses like us.
IT Manager of a Trucking company, OH