background preloader

Jon's Excel Charts and Tutorials - Index

Jon's Excel Charts and Tutorials - Index

Related:  HOW TO?ExcelExcelVisual information resources

Butterfly Chart – Excel Chart with Dual Converging Scales A Butterfly chart is a chart where two entities are compared side by side using scales meeting at the center. Due to its shape, the chart resembles a butterfly and hence the name. These charts are sometimes also known as Funnel or Tornado Charts though I find “butterfly” to be a better description as it allows for a greater variation in shape than a funnel or a tornado does ! So let’s jump straight into creating a beautiful looking butterfly chart. What to do when Excel won't let you insert columns By David H. Ringstrom, CPA From time to time you might encounter the prompt that appears when Excel thinks you can't add additional columns or rows. This occurs when Excel considers used range of the worksheet to encompass all columns or rows. In this article I'll describe some techniques you can use to overcome this problem.

AJP Excel Information Charting Examples Excel Charting techniques, solutions and examples Chart Pattern Fill PowerPoint Add-In for applying Pattern fills to charts, tables and shapes in PowerPoint 2007 Ratio Plotarea The Data Visualization Beginner’s Toolkit #2: Visualization Tools (Note: if you are new to this series, the DVBTK doesn’t teach you how to do visualization. Rather it is meant to help people find a less chaotic and more effective path towards the acquisition of the necessary skills to become a data visualization pro. To know more, make sure to read the introduction to the series first.) The DVBTK #1 introduced books and study material to make sure you acquire the right knowledge in the right order. Studying is the first step and there’s no level of practice that can substitute for it.

The Daily Graph "The Daily Graph" re-creates charts from The Economist's Graphic Detail blog using standard run-of-the-mill Excel techniques without macros. We do try to milk Excel for all it's worth and apply techniques that may not have been intended in the way we use them. In the end, it's the result that counts. "The Daily Graph" is published whenever we spot an interesting chart on The Economists's blog that looks like it cannot be done in Excel. Typically once or twice a week if we can find the time.The Daily Graph blog comes with a dowloadable version of an Excel workbook so that you can follow what we did... or you can "borrow" our work and use it for something entirely different. "The Economist" is a trademark of The Economist Newspaper Limited.

Check Multiple Criteria with Excel INDEX and MATCH The INDEX function can return a value from a range of cells, and the MATCH function can calculate a value's position in a range of cells. For example, in the screen shot below, cell A7 contains the item name, Sweater: the MATCH function can find "Sweater" in the range B2:B4. The result is 1, because "Sweater" is in the first row of that range.the INDEX function can tell you that in the range C2:C4, the first row contains the value 10. Using structured references with Excel tables Structured references make it much easier and more intuitive to work with table data when you are using formulas that reference a table, either portions of a table or the entire table. They are especially useful because table data ranges often change, and the cell references for structured references adjust automatically. This minimizes the need to rewrite formulas as rows and columns are added and deleted in a table, or when external data is refreshed. In this article The Department Sales table example The following is an example, referenced throughout this article, of a table that is based on sales in a department of six employees with the latest sales amounts and commissions.

Task-Centered User Interface Design : Main page and Shareware Notice The suggested shareware fee for this book is $5.00, payable to Clayton Lewis and John Rieman. Send it to: Clayton Lewis and John Rieman P.O.Box 1543 Boulder, CO 80306 USA. How to Create a Panel Chart in Excel To show a concise, clear summary of data for several departments or cities, you can create a panel chart in Excel. It shows all the data in a single chart, with vertical lines separating the groups. My chart shows sales for bars and cookies, in four cities, over the first 7 months of the current year. I learned this technique from Jon Peltier's website, where he also sells a Panel Chart Utility, that creates dot plot and bar panel charts. Panel Chart Steps The instructions for making a panel chart look long and complicated, and I've avoided learning this technique, because it was a daunting process.