You may already be familiar with the Conditional Formatting tool in Excel. The amazing tool that improves how we view and visualise our data.
Well unfortunately Excel does not yet have a Conditional Formatting feature that we can apply to charts. I have great news though. There is a way that we can do it, and it is not difficult.
This blog post will look at two examples of Conditional Formatting with charts so that you get a feel for how to do it. You can then apply the same technique to whatever example you need.
Highlight a Column Based on User Selection
In the first example shown in the image below. We want to be able to highlight the column in each chart that corresponds to the product type selected by the user in cell B3.
When creating reports in Excel, a common requirement is to report on a rolling basis. For example, this could mean the last 12 months, the last 6 weeks or the last 7 days.
Whatever the timeframe being reported, this can mean a lot of time editing chart sources and formulas to show the right data.
This blog post looks at creating a dynamic rolling chart to show the last 6 months of data, so when new data is added to the table, the chart automatically updates to report the last 6 rows (months).
Continue reading Posted in Advanced, Charts, Dashboards, Excel | Tagged dynamic chart, dynamic named range, dynamic range, excel dashboards, Excel Formulas, Excel functions, great excel functions, last 6 months, line graph, offset function, Rolling Chart, special excel functions | When using column charts to compare values, you may want to highlight the maximum and minimum values on the chart. By highlighting these columns it removes any confusion when trying to view the top and bottom values. Finding the Max and Min Values To show the max and min values on a column chart, we will first need to identify the max and min values of our range. These values will then be used as a second data series when we create the column chart. Continue reading
On the eve of the FIFA World Cup 2014 I have created a world cup history dashboard full of fascinating statistics from the previous 19 world cups.
I find creating spreadsheets involving your passions a great way of developing and testing your Excel skills
This dashboard incorporates a few different Excel dashboard techniques which are explained in this post.
The spreadsheet is completely unprotected so all the formulas and code can be explored.
scrollable chart is a great trick for enhancing the functionality of your Excel dashboards. You may have years of data to display in the chart, and yet space is limited on your spreadsheet.
adding a scroll bar to the chart, users can interact with the chart and scroll to see the data they want displayed.