A waterfall chart shows the impact of a series of changes on an initial value to produce a final value, for example changes in a budget or forecast between two years. Unfortunately, this is not a standard chart in Excel’s selection so we will look at how to create it. Continue reading
Tag Archives: Charts
Genealogy Chart
Today we are going to apply a few tricks to create a genealogy chart. (I had to check my spelling – it is often misspelt as geneology and geneaology.) This is equivalent to creating a Gantt chart if you are scheduling a project. I am going to use the genealogies in the Bible in Genesis chapters 5 and 10 as my data set. Continue reading
Automatically Changing Named Ranges
Reply
Automatically changing named ranges can save you time, avoiding the need to manually change the chart data range as new data is added, for example, for monthly reports. The key to this is using the OFFSET function when defining the name. Continue reading
Introduction to Charts
Learning to create charts or graphs is an important skill to learn for Excel users. Charts can show relationships between numbers visually which may not be obvious by looking at a screen full of numbers. A common obstacle when creating charts is addressed. The file from the Power Comparison post is used as an example. Continue reading