Skip to content

Swiss Army Spreadsheets

How to do just about anything with software you already have

  • Home
  • About
  • All
  • Author
  • Presentations and Publications
  • Welcome to Swiss Army Spreadsheets

Month: January 2011

Project 2: Bar charts & Library stacks

January 29, 2011 gexner

As I’ve said before, bar charts are good for comparing distinct values. Unlike pie charts, which only need a minimum of two values to be informative, bar charts usually have more. Usually I wouldn’t think about a bar chart unless… Read moreProject 2: Bar charts & Library stacks

Charts: Adding context

January 24, 2011 gexner

Now, I’ve explained how to create various simple charts, but you may have noticed that there’s something all of my examples were missing. Take for example, our basic pie chart. Imagine coming back to it a year or more after… Read moreCharts: Adding context

Line charts: Basic how-to

January 16, 2011 gexner

To make a line chart in a spreadsheet, all you strictly need to start with is a set of numbers. Line charts typically compare the values of several items — often but not exclusively the value of a single item… Read moreLine charts: Basic how-to

Bar vs Column Charts: How to choose

January 14, 2011 gexner

Earlier, I said I’d discuss how to choose between bar charts and column charts. I make my choice based on three main considerations – subject, shape, and space.

Bar charts: Basic how-to

January 10, 2011 gexner

To make a bar chart in a spreadsheet, all you strictly need to start with is a set of numbers. Bar charts typically compare the values of two or more items, although it could be argued that the iconic goal… Read moreBar charts: Basic how-to

Pie charts: Basic how-to

January 3, 2011 gexner

To make a pie chart in a spreadsheet, all you strictly need to start with is a set of numbers. Pie charts show the percentage of the whole, so at minimum for a reasonable pie chart you need 2 numbers,… Read morePie charts: Basic how-to

Recent Posts

  • Working with big data sets: using different functions
  • Working with big data sets: streamlining formulas
  • How big is big?
  • The same but different: conditional formatting in adjacent cells
  • Identifying opening and closing tags

Archives

  • January 2014
  • December 2013
  • November 2013
  • September 2013
  • August 2013
  • July 2013
  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • November 2012
  • October 2012
  • September 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • May 2011
  • April 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010

Categories

  • Uncategorized

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
© 2025 All rights reserved
Proudly powered by WordPress | Theme: Simple Life by Nilambar.
Go to top