• 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 / 12 Month Data Graphic Shape (almost)

12 Month Data Graphic Shape (almost)

April 25, 2007 By Visio Guy 10 Comments

This morning I was thumbing through one of Edward R. Tufte’s books, and I got this idea for a “12-month bar shape” — a shape that shows vertical bars for each month of the year, in a compact, easy-to-read format. My original thought was that it would make a perfect Visio 2007 Data Graphic!

So, without thinking, planning, or researching, I plunged ahead creating the details of the shape, and then realized that making a Data Graphic is more complicated than I thought. Ugh!

Nevertheless, I’ve created a shape, which displays bar-graphics for 12 months of the year, and which links to external data. Perhaps you’ll find it useful!

Since the shape I created requires 12 months of data plus an ID, it wasn’t exactly clear to me how I could make a single Data Graphic shape out of it. I need to do some more research on how to integrate a shape into Visio’s Data Graphic, which really means that I need to re-read: Building Custom Data Graphics for Visio 2007 !!!

But the shape is pretty cool, so I figured I’d just call it The First Step, and simply link the master to data. So the shape isn’t a Data Graphic, but it does link to external data.

If you have data that has fields named: ID, Month 01, Month 02,…Month 12, then this shape will be automatically link it’s Shape Data fields to your data. In the download .zip, I’ve provided a sample Excel-file that provides the Visio file with appropriately structured external data.

Below, you can see an example of several 12 Month Bar shapes in action, shamelessly showing off Visio 2007’s cool new Theme-ing. Note that the shapes are linked to the data shown in the bottom window. This data in turn comes from the Excel file.

12 Month Data Shape Examples

click to view larger image

Note: When you open the Visio file, you might have to re-connect the External Data to the spreadsheet: 12 Month Data.xls. You can do this via the menu item: Data > Link Data to Shapes…

I hope you find this shape useful, and would love to hear your comments about it!

Download “12 Month Visio Data Graphic Shape”

s!Aj0wJuswNyXlhQgvHpmm60QCUtZ_ – Downloaded 2553 times – 103.00 B

(Download 12MonthDataShape.zip)

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

Related posts:

  1. Forefront Icons and Data Graphic Shapes
  2. Data Graphics Resources
  3. Visio Film Strip Shapes: Hurray for Hollywood!

Filed Under: Shapes, ShapeSheet Tagged With: Data Graphics, Data Linking, Visio SmartShapes

Previous Post: « Map of World
Next Post: Data Graphics Resources »

Reader Interactions

Comments

  1. Mark Nelson (MS) says

    May 1, 2007 at 5:43 am

    Looks good. Now let’s see this as a Data Graphic! Check out the Multi-bar Graph callout that is one of the built-in Data Bars. It demonstrates how to get multiple Shape Data fields into one callout. It’s a bit complex in the Shapesheet but well worth it.

  2. Visio Guy says

    May 1, 2007 at 8:19 am

    Thanks Mark! I had a feeling I had missed something that someone else had already built!

    – Chris

  3. Stanley says

    February 10, 2008 at 11:53 pm

    Hi,

    I am trying to use the shape that you have created.

    But how do I link to the Excel spreadsheet? You have the note that says: “When you open the Visio file, you might have to re-connect the External Data to the spreadsheet: 12 Month Data.xls. You can do this via the menu item: Data > Link Data to Shapes…”

    I do not have Data as a menu item. I have Visio Professional 2003. Please, wheat am I missing?

    Stanley

  4. Visio Guy says

    February 11, 2008 at 2:08 am

    Hi Stanley,

    The Data Graphics feature was added in Visio 2007.

    You might also be able to hook this to your data using some of Visio’s other capabilities. Have a look at:

    Tools > Add-ons > Visio Extras > Database Wizard…

    Good luck,

    – Chris

  5. Stanley says

    February 11, 2008 at 3:02 am

    Hi Chris,

    OK, I learned about Tools > Add-Ons > Visio Extras > Database Wizard.

    But something happens that confuses me right at the end of thes process, and if you could answer this it would help tremendously.

    I proceed by gong to Next > Link shapes to database records > Shape(s) in a drawing > 12 Month Data Shape.vsd, which I downloaded from your site, and I choose one of the shapes, so I continue with Next > Excel files > I browse to 12 Month Data.xls, which I also downloaded from your site.

    At this point, I need to define a table or select a table (what does that mean?) and if I click “Define Table” then I don’t know what to do.

    Could you please help me out just from that point, and then I will be all set.

    Thank you.

    Stanley

  6. Visio Guy says

    February 11, 2008 at 8:07 am

    Hi Stanley,

    I opened up the Excel file, selected all the data, then named it by typing “Data” in that little text box at the top-left of the Excel interface.

    Then, when you rund the Database Wizard, you’ll see the “Data” table in the wizard screen where you encountered trouble.

    In another dialog, you’ll have to match the data fields in the shape with those in the Excel file. For instance, for April, you’ll have to link “Prop._VisDM_Month_04” in the shape with “Month 04” in the Excel file. Gotta do it 12 times, but then the shape is linked, as are any copies of the shape!

    Hope this helps,

    – Chris

  7. Stanley says

    February 11, 2008 at 1:36 pm

    Hi Chris,

    OK. Got it. Great!

    One last, quick question.

    In your view above, you show the Excel file right below your Visio shape. How do I do that?

    Thank you.

    Stanley

  8. Visio Guy says

    February 11, 2008 at 6:13 pm

    Hi Stanley,

    That view is part of the new Data Graphics feature in Visio 2007.

    – Chris

  9. Cameron says

    June 18, 2008 at 7:15 pm

    Hey guys, I have been desperately searching for information on the data graphics. It seems like a very cool feature, but for the life of me I cannot see the data graphics option. I am using Visio 2007 SP1. I’ve tried adding numerous shapes that have some shape data such as a process box. The shape data has a cost field that I have set the value to $10,000. When I have the shape selected (verified by the fact that I can see the Shape Data pane open), I go to Data, the only options I see are Shape Data, Insert Data Solutions, and Reports.

    Help please! What am I doing wrong?

  10. Visio Guy says

    June 18, 2008 at 8:53 pm

    Hi Cameron,

    I looked at the Microsoft Office Visio 2007 Edition Comparison matrix, and it says the Data Graphics features are only available for Visio Professional 2007. Perhaps you have Standard?

    – 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
  • Free Visio People Shapes
  • Sankey Diagram Shapes for Visio
  • Bubble Revision Shapes
  • Visio Network Server Shape Icon Customization Tool
  • AV Engineering Diagrams with Symbol Logic ECAV
  • Release the Power of Visio Custom Line Patterns
  • Crayon Visio Network Shapes, Revisited

www.visguy.com - Visio Guy - since 2006

 

Loading Comments...