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

Browse by Tags

  • 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...
  • 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...
  • Simple Gantt Chart

    I recently discovered how quick it is to create a simple Gantt chart in Excel. The following example was created for Excel 2003. It should work the same for other versions. Create a worksheet similar to the above table. Note: the formula in column D2 is =C2-B2. You’ll need to set the Cell Format back to General, or [...] Read More...
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.