• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Visio Guy

Smart graphics for visual people




  • Home
  • Hire Me
    • Hire Me
    • Résumé
  • Products
    • Products
    • Bubble Revision Shape
    • Layers to Pages Utility
    • Rack Unit Dimension Line
    • Radial Elements Tool with up to 100 Wedges
    • Text on a Circle Visio SmartShape
  • Index
    • Articles by Date
    • YouTube – VisioGuy
    • Download Information
    • Suggestion Box
    • Shop
    • Visio Art
    • Visio Links
    • – Visio Shapes & Stencils
    • – Visio Templates & Drawings
  • About
    • About
    • Donate
    • GitHub
    • jsFiddle
    • Reading List
    • Subscribe & Follow
      • – E-mail
      • – facebook
      • – Twitter
      • – RSS
    • Privacy Policy
  • Discussion Forum
You are here: Home / Visio Content / Shapes / Charts & Graphs / Top Visio Guy Downloads (as of November 2009)

Top Visio Guy Downloads (as of November 2009)

November 10, 2009 By Visio Guy 6 Comments

top-visio-guy-downloadsSee what other Visio Guy readers are downloading, and see how I visualized the download statistics!

Back in May of 2009, I installed a neat plug-in to this WordPress blog. The WordPress Download Monitor plug-in allows me to track how many times the free content on Visio Guy gets, well as you might guess, dowloaded.

I’m hoping that I will be able to get a better picture of what readers are interested in, and address those topics with more content, tutorials and how-to articles.

I haven’t linked every single Visio Guy download to the Download Monitor yet, but I’ve tried to pick what I felt were the more popular ones.

Top Downloads by Volume

If we look at the top ten downloads, as of November 2009, we see that we mostly have posts that are over five months old!

  1. (6.0 months, 606 downloads) Oblique Connectors (Visio 2007 version)
  2. (6.1 months, 560 downloads) Free Visio People Shapes (Visio 2007 format)
  3. (6.0 months, 549 downloads) Map of World (Visio 2002 version)
  4. (5.0 months, 317 downloads) Apple iPhone Network Shape (Visio 2007)
  5. (6.1 months, 315 downloads) Free Visio People Shapes (Visio 2002 format)
  6. (5.0 months, 276 downloads) Circular Text Generator, v2 (Visio 2007)
  7. (3.2 months, 255 downloads) Automatic Chevron Process Shape
  8. (6.1 months, 241 downloads) Circular Multi-arrow (Visio 2007 format)
  9. (1.9 months, 233 downloads) Visio Network Server Icon Customization Tool
  10. (6.0 months, 227 downloads) Map of World (Visio 5 version)

Top Downloads by Intensity

As I so often find when I look at data these days, the numbers are nice, but fairly meaningless, because they can’t be properly compared. When you look at a grand total of downloads, it doesn’t necessarily tell you how popular a download is. It might just be telling you how old a download is, or how well Google and Bing happened to have found it!

If we look at the rate at which items are downloaded per month, we get a more interesting story:

  1. (187.0 downloads/month, 0.5 months) Follow the Money Sankey Diagram
  2. (176.6 downloads/month, 0.2 months) Visio Radial Elements Tool
  3. (120.2 downloads/month, 1.9 months) Visio Network Server Icon Customization Tool
  4. (101.4 downloads/month, 6.0 months) Oblique Connectors (Visio 2007 version)
  5. (92.1 downloads/month, 6.1 months) Free Visio People Shapes (Visio 2007 format)
  6. (90.8 downloads/month, 6.0 months) Map of World (Visio 2002 version)
  7. (80.9 downloads/month, 3.2 months) Automatic Chevron Process Shape
  8. (76.5 downloads/month, 1.3 months) Village of 100 People Diagram Template
  9. (63.5 downloads/month, 5.0 months) Apple iPhone Network Shape (Visio 2007)
  10. (56.7 downloads/month, 3.8 months) Connect Shapes in Order
  11. (55.3 downloads/month, 5.0 months) Circular Text Generator, v2 (Visio 2007)
  12. (51.8 downloads/month, 6.1 months) Free Visio People Shapes (Visio 2002 format)
  13. (47.1 downloads/month, 1.4 months) Double-headed Cross Functional Flowchart Horizontal (US Units)
  14. (39.7 downloads/month, 6.1 months) Circular Multi-arrow (Visio 2007 format)
  15. (37.6 downloads/month, 6.0 months) Map of World (Visio 5 version)
  16. (33.0 downloads/month, 5.0 months) Circular Text Generator, v2 (Visio 2002)
  17. (24.8 downloads/month, 1.8 months) Visio Marketing Pyramid Shapes
  18. (24.2 downloads/month, 5.0 months) ThinkPad Shape (Visio 2007)
  19. (22.9 downloads/month, 4.3 months) Visio Twitter Word Cloud
  20. (22.9 downloads/month, 2.1 months) Visio Spectrum Shape
  21. (22.9 downloads/month, 6.1 months) Circular Multi-arrow (Visio 2002 format)
  22. (19.1 downloads/month, 6.0 months) Word Balloon Shape (Visio 2007 version)
  23. (17.6 downloads/month, 3.7 months) Clippy Visio SmartShape
  24. (17.6 downloads/month, 0.9 months) Choose Colors with Shape Data Fields
  25. (14.4 downloads/month, 5.8 months) Data Refresh on Open
  26. (6.6 downloads/month, 5.7 months) Northwest Airlines Volume Gauge Shape (Visio 2007 format)
  27. (3.8 downloads/month, 5.6 months) VbaPropertyGenerator Code Module

We can see that there is a nice mix of downloads that have different ages.

Now items #1 and #2 haven’t been up for very long and show some skewing in the other direction. Because they are young, hot and on the front page, their per-month projections are warped on the high end. So we should probably throw out at least the first two items from this list.

Getting Download Data from WordPress

If you’re a blogger who uses the Download Monitor plug-in for your WordPress blog, you might  interested in how I got this data. It turns out that the plug-in adds several tables to your WordPress database:

  • vg2006_DLM_CATS
  • vg2006_DLM_DOWNLOADS
  • vg2006_DLM_FORMATS
  • vg2006_DLM_LOG
  • vg2006_DLM_META
  • vg2006_DLM_STATS.

Using the dataphpMyAdmin control panel available from cpanel on my web host, I was able to select some columns from vg2006_DLM_DOWNLOADS and export them to an Excel 2000 format.

Once I had the data in Excel, I could massage the data, calculate the age of posts in months and days, sort by downloads and downloads-per-month, and even build the “<a href=”” tags needed for the lists above!

Visualizing the Download Data in Excel

Once I had downloads/day and downloads/month calculated, I found that Microsoft Office Excel 2007 has a nifty way to make bar-graphs, right in each cell:

excel-download-rate-data

click to view larger image

You’ll find the feature in the Insert Ribbon tab, under the Conditional Formatting button:

excel-format-bars-in-cellsclick to view larger image

Visualizing the Download Data in Visio

Now the in-cell bars are nice and compact in Excel, and Excel has a bevy of other graphic capabilities, but I thought perhaps Visio could handles stuff like this too.

Excel is surely a more adept graphing application than Visio, but with Visio and a bit of ShapeSheet knowledge, you can create custom elements for your bar graphs.

Here, I created a bar-graph shape that shows the article title, the number of downloads-per-month, and it displays a thematic download arrow at it’s far end:

follow-the-money-bar-shape

Try doing that in Excel!

Once I had the basic shape working, and the geometry and text linked  Shape Data fields, I was able link my Excel data to many instances of it.

First, I used to use Visio 2007’s Data > Link Data to Shapes… feature to import my download Excel data. Then, I gave the bar shape’s Shape Data fields names that matched the column-headers in that data. This made it easy to automatically link the imported Excel data to the shapes.

You can see what it looks like in Visio here:

smartshape-graph

click to view larger image

After a bit of aligning and repositioning, and the final graphic looked like this:

visio-download-rate-graphclick to view larger image

If there’s enough interest in how I did this (read: LEAVE A COMMENT BELOW!) perhaps I’ll talk more about how I created the shapes and linked them to data in future posts.

  • Tweet
  • More
  • Pocket
  • Share on Tumblr
  • Print
  • Email

No related posts.

Filed Under: Charts & Graphs, News

Previous Post: « Kill the Reviewing Toolbar!
Next Post: Remove Backgrounds From Images With Office 2010! »

Reader Interactions

Comments

  1. Vincenzo says

    November 11, 2009 at 12:43 pm

    The large number of download of Sankey diagram stencil is due to the fact that it does not exist on the internet a powerful free sankey diagram editor and the stencil you proposed , at least , help drafting simple diagram. It would be nice to develop more this tool .
    Cheers

  2. Visio Guy says

    November 16, 2009 at 12:39 pm

    Hi Vincenzo,

    Have you seen these?

    Sankey Diagram Shapes for Visio
    Pre-wired Sankey Diagram Shapes
    Visio Guy: Sankey Diagrams

  3. hitita says

    November 25, 2009 at 10:52 am

    Lot of thanks for share all this information with us VG

  4. Visio Guy says

    November 26, 2009 at 3:12 am

    You’re welcome hitita! Thanks for stopping by and leaving a comment!

  5. 888mikey says

    August 25, 2010 at 11:22 pm

    where do i download this after logging in?

  6. cm0s says

    January 28, 2013 at 6:25 pm

    Hi,

    I saw that this post is quite old, but never the less, I’d like to know more about how you finally linked the excel data to the stencil!

    Cheers,
    Chris

Leave a Reply Cancel reply

Primary Sidebar

Buy Text on a Circle Shape
Article — Video — Purchase

Categories

Buy my book!

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Tag Cloud

A/V Artistic Effects BPM Code Connectors Control Handles Countries Custom Patterns Custom Properties Data Graphics Data Linking Data Visualization David Edson David Parker Fill Format Formulas Functions Geometry Gradient Images Links Maps Multi-shapes Network Programming repeating shapes Resources Right-Click Actions Scale Shape Data ShapeSheet ShapeSheet Formulas ShapeSheet Functions SharePoint shiny SmartShapes Sport Sports Text Themes Tools Transparency User-defined Cells Visio 2007 Visio SmartShapes

Top Posts & Pages

  • - Visio Shapes & Stencils
  • - Visio Templates & Drawings
  • Amazon AWS Visio Shapes
  • Dynamic Updating Org Charts in Visio!
  • Text on a Circle Visio Shape
  • Bubble Revision Shapes
  • Crayon Visio Network Shapes, Revisited
  • Map of World
  • Sankey Diagram Shapes for Visio
  • AV Engineering Diagrams with Symbol Logic ECAV

www.visguy.com - Visio Guy - since 2006

 

Loading Comments...