A Pareto chart in Excel is a chart which is made up of a column chart and a line chart to show a cumulative position. This is often a good chart to show an 80 20 scenario, where 80 % of the costs are achieved by 20% of the cost drivers. The chart can be created by segmenting the the data into cost drivers or buckets. If your business expenses were allocated into the following buckets:
Infographics in Excel is not a new concept but these sort of graphical representations are very powerful and convey a striking message. Infographics are usually not as dynamic as a dashboard, they tell a striking story. This is not to say that the source data which populates the infographic can't be dynamic in nature.
My website is about to explode with Infographics as I publish a swath of interactive Excel Infographics for people to plug and play with.Read More
I have been quiet on my blog of late. Been busy preparing courses and webinars for the year. This morning a put together a fresh dashboard for the site. The Excel dashboard has a consistent feel and I have used 3 years as an example. It spins on the option buttons in the top right. It is only a very small dataset but works nicely. The staffing by state chart works nicely.
I will attach the file to show how the Excel dashboard is put together.Read More
Recently I have been creating some comparison charts (prior year agains projections) and usually the numbers in my tables have been in a format which would suit. In this recent project though the data was in large whole numbers and I wanted to format this into a chart so it appeared as millions. In order to get from whole numbers to millions I had to work with the number format in what was a slightly unintuitive way and I hope by sharing this that I save you some time in the process.Read More
Convert Formula to Relative or Absolute April 10, 2019
Convert Entire Excel Workbook to Values March 11, 2019
Evaluate with Excel to Extract Sequence March 6, 2019
Extract the First Item from a Horizontal List February 27, 2019
Create Number Sequence with VBA Custom Function January 15, 2019
Protect a Worksheet, Use the Autofilter October 18, 2018
Countifs Across Sheets October 10, 2018
Excel VBA to Select Sheets September 22, 2018
Power BI Desktop Dashboard August 20, 2018
New Excel Dashboard Tools August 1, 2018