Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Browse by Tags

  • TM AutoChart: Connect chart axis parameters to cell values

    TM AutoChart is a shareware Excel add-in that links the minimum, maximum, major, and minor values of a chart axis to worksheet cells. http://www.tushar-mehta.com/excel/software/autochart/index.html Over the past few months I have been trying out different Ribbon layouts for chart related add-ins. For now, I have settled on a split button where the large button provides [...] Read More...
  • Modern Excel Charts

    Debra sez: If you want to make your Excel charts look like they were made in 2010, instead of 1982, see the Excel Charting tutorials on Jon Peltier’s blog. However, if you feel like kicking it old skool… Problems: I couldn’t read the title and y-axis, so I took a stab. I don’t know how to turn the y-axis text [...] Read More...
  • Charting House

    I was watching a DVR’d episode of House recently and I became aware that the amount of show between commercials was changing as the show went on. The commercials were getting closer together. Then at the end, a long run of show between the last commercial and the credits. I did what [...] Read More...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.