Filter the data series shown on a graph; Issue #463 April 28, 2020

On a recent AFP webinar discussing what CEOs and Boards are expecting from the Finance department during these turbulent times, cash flow forecasting was clearly the biggest request. It was clear that finance teams are having to generate multiple future scenarios...

Creating area graphs with Charticulator; Issue #460 March 17, 2020

What can you do if you want to create a chart but the values you have differ by an order of magnitude or more? If you use the standard column or bar graph, you risk the smaller values being virtually invisible because the chart is scaled to show the large values. In...

Scaling values for related data series; Issue #458 February 18 2020

It is not uncommon that to communicate a message you need to show two or three related data series. It is relatively easy to create a single graph that has all the data series shown. The challenge comes when you have values in the data series that are different by an...

25 Advanced Excel Chart Tips and Tricks (video)

Basic Excel Chart Skills Intermediate Excel Chart Skills Advanced Excel Chart Skills Training Workshops Excel Chart Articles Videos & Online Courses 25 Advanced Excel Chart Tips and Tricks (video) These 25 tips and tricks will help you take your skills in creating...

Lining up related column graphs at the horizontal axis

Basic Excel Chart Skills Intermediate Excel Chart Skills Advanced Excel Chart Skills Training Workshops Excel Chart Articles Videos & Online Courses Lining up related column graphs at the horizontal axis The challenge If you have related column graphs, how do you...