Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Daily Dose of Excel » All Tags » Charting (RSS)

Browse by Tags

  • Visualizing data in Excel: How would you interpret this graphic?

    Because I have no clue. It’s from an university alumni magazine. The names I’ve smudged (or tried to anyways) are the various colleges. Could this graphic be done in Excel? Yes. Should it? Read More...
    Filed under:

  • Visualizing data in Excel: Balancing the physical and logical dimensions of a chart

    When Excel creates a chart it assigns, by default, certain physical dimensions to the chart. These physical dimensions (height and width) are independent of the logical content of the chart. So, in the case of a column chart the physical shape of the chart is the same irrespective of whether it contains 2 [...] Read More...
    Filed under: , ,

  • Bar Is the New Pie

    Everyone is sick of talking about how pie charts suck. And whenever I do a charting post, it’s trouble. So this post is destined for failure. However, I was thinking about pie charts recently. I don’t have the disdain for pie charts that some do, but I generally agree with the [...] Read More...
    Filed under:

  • NFL Slotting

    Peter King at SI says: The NFL has a slotting system that is ever-so-slightly malleable, where a player who gets drafted one spot lower than another player occasionally gets a smidgeon of a better deal. And sometimes a quarterback gets an above-market deal. But position players and non-quarterback skill players are slotted, and despite the efforts [...] Read More...
    Filed under:

  • Golf Charts — Another Take

    Inspired by Dick’s interest in charts, I took a look at how I would have presented the data. Some overall thoughts. I used Office 2010 beta for the charts shown below. There was not much, if any, difference between what I would have got with Excel 2007. I also stayed with the default [...] Read More...
    Filed under: ,

  • Golf Charts

    After week 8 of my golf league, I decided to have a chart-of-the-week. Now, for the first time ever, you can view all the charts o’ the week in one place with author commentary. Week 8 After scoring week 8, I noted that I was plummeting down the leaderboard while Miller seemed to be scoring well [...] Read More...
    Filed under:

  • The Big Bang Servo Diet

    From Philip Greenspun You draw a line from the current weight/date to the desired weight/date. Every morning you weigh yourself and plot the result. If the point is below the line, you eat whatever you want all day. If the point is above the line, you eat nothing but broccoli or some other low-calorie food. The thing [...] Read More...
    Filed under:

  • Reading XML Files in VBA

    In Creating State Maps... I copied some data out of an XML file and graphed it into a state map. I wanted to try to read the XML file directly in VBA because I've never done it before. First, I set a reference to Microsoft XML v6. Six was the newest version [...] Read More...
    Filed under: ,

  • Creating State Maps with XY Charts

    According to eggheadcafe, Excel doesn't have built-in maps anymore. I'm not a charting guy, as you know, so I didn't know that. I also didn't know that they ever did. But I wanted a map of the US with sales by region. That seems possible, but all I got this time [...] Read More...
    Filed under:

  • Data Sets

    I like finding data sets on the internet. Like at mathforum.org and other resources at mathforum.org. Now we can answer the age-old questions like, Where do women outlive men by the largest margin? I guess they kept the women-folk away from Chernobyl. It does raise the question of why I can’t prevent Bangladesh’s [...] Read More...
    Filed under:

  • Historical U.S. Tax Rates

    I heard a lot of news about ‘tea parties’ going on yesterday. If you don’t know, tea parties are supposed to mimic the Boston Tea Party, where New Englanders complained that they were paying tax, but had no say in government, i.e. taxation without representation. That got me wondering why people would be participating in [...] Read More...
    Filed under:

  • Green Eggs and Ham

    via Kottke After writing The Cat in the Hat in 1955 using only 223 words, Dr. Seuss bet his publisher that he could write a book using only 50 words. Except that the website with the text has a typo which puts the word count at 51. At least that’s what I think. I don’t [...] Read More...
    Filed under:

  • Excel Movie Reviews

    I recently watched The Contract. It was terrible. It was worse than The House Bunny (my wife picked that one, I swear). You’re probably saying, “I like John Cusack. I like Morgan Freeman.” Yes, they’re good. Everyone else in the movie is terrible. How does a really bad movie become [...] Read More...
    Filed under:

  • Counting Olympic Medals

    I saw this article in the LA Times about measuring Olympic Medals per capita. I like the idea, but I also think figuring in the GDP of the country makes sense. The US could throw a lot of money at an individual event and probably fair pretty well. I got the GDP via Wikipedia [...] Read More...
    Filed under:

  • Peltier Loves Pie

    I’m testing out widgenie (beta) and want to see how an embedded chart looks. I chose a pie chart because I’ve been reading lately how we all know pie charts are bad. Anyway, this took about 10 seconds to create with Debra’s sample data. var myLogiWidget477e7c06_b129_47f5_b60b_617dfb112792 = new rdLogiWidget; [...] Read More...
    Filed under: ,
1 2 Next >
Copyright Excel User Group and the relevant contributors, 2009. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.