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
XLookup to the Party August 31, 2019
Populate a Userform with VBA August 14, 2019
New Dashboard Ideas August 9, 2019
Excel Custom Sort August 7, 2019
Excel VBA Remove Duplicates Multiple Columns August 6, 2019
The Tennis Chart July 17, 2019
Smallman Interview July 15, 2019
Excel Summit South 2019 July 12, 2019
Sales Excel Dashboard June 14, 2019
Using the Wildcard with SUMPRODUCT May 30, 2019