Sales Analysis Charts in Excel – 78 Alternatives
Recently, I ran a contest asking you to analyze a bunch of sales data and present your results in charts. We received a total of 78 charts from 45 people. The contest entries had a mind-boggling variety of excel charts, techniques and ideas. It took me a while to go thru all the files and compile the results. Thanks for your patience. In this post, you can find all the charts along with my comments & links to download files.
Excel Links – Updates on Singapore Workshop Edition
It has been a while since we had an Excel Links post. So here we are.
First, I want to update you about our Singapore Workshop.
As you know, we have opened the registrations for this workshop last week. If you are in Singapore and want to attend an Excel & Financial Modeling Workshop, Please consider joining us on July 8- 10. For details & enrollment, visit Singapore Bootcamp page.
Apart from the Singapore workshop, I was busy last week conducting live training at CapGemini, in their Hyderabad office on Excel & Dashboards. It was a very good experience. I learned a lot about practical challenges people face when doing sales reports etc. using Excel.
Automating Repetitive Tasks
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
Over at Newton Excel Bach I spotted the Dynamically Defined Dancing Pendulums. Doug had used Strand7 for the animation.
I thought I could do that in Excel and did.
This post demonstrates some of some basic VBA techniques used to simplify repetitive tasks used during the construction of the project.
For a full project description visit Excel Hero.com.
We Want Your Ideas
Chandoo.org is looking for your ideas!
What would you like to see discussed in future posts at Chandoo.org ?
Analyse Data like a Super Hero
Can I automate 500 Columns of Data Analysis without VBA?
Absolutely!
Excel super function – Data Table to the rescue.
After reading this post, you will be able to process data like a Data Analysis Super Hero !
Register for our Excel & Financial Modeling Bootcamp in Singapore [Details inside]
Hello Friends & Readers,
Our Singapore Excel & Financial Modeling Boot-camp is ready for your consideration.
We will be conducting it from July 8th to 10th.
Please read this short page to know details about the program and how to enroll.
Who is this boot-camp for?
This boot-camp is aimed at business analysts, financial analysts & managers, who use Excel all the time. If you are an Excel new-bie, this boot-camp is not for you. Otherwise, you will enjoy this.
Win Loss Chart from a Series of Win, Loss Data
Last week, we learned how to create win-loss charts in Excel. In the comments, Dan said,
“Incidentally, the fastest way to do this would be using SFE, just reflect your data with 1 for a win, – 1 for a loss. There’s even an option to automatically invert negative numbers.”
Of course, we can use the beautiful Sparklines for Excel addin to do this and several other charts. But if you just have a series of Wins and Losses, like below, you can use a column chart to create win loss charts too.
Today, we will learn how to create a win loss chart from a set of win, loss data in Excel.