You may not want to permanently maintain the order of a chart, instead wanting it to dynamically update the order based on the results. Using pivot tables, you can quite easily sort the results ascending or descending and add a filter to only bring back the top ‘x’ results. Here is an example of how to do Read More …
Month: May 2017
Conditional formatting on an Excel bar chart
Excel charts can’t use conditional formatting in the traditional sense, but there are various tricks you can use to imitate conditional formatting within your charts. A classic example would be wanting to RAG (Red Amber Green) rate your bar chart. Perhaps you want values under 50% to be displayed with red bars, under 75% Read More …
Using wildcards and searching specific text in Excel
When you want to search for some specific text rather than an exact match, you might be used to using wildcard characters in other programs. For example, the asterisk * is the wildcard in Microsoft Access and can be used alongside the Like operator. On a list of US states if you added criteria of Read More …
Graph trendlines
To add a trendline to your Excel chart or graph, right-click on the data series and go to ‘Add Trendline’. You will be met with the following options: Exponential These are curved trendlines useful when your chart is demonstrating growth at increasing rates. For example, the growth of computer processing power has continued at an exponential Read More …