All articles with 'charting' Tag

12 Steps to become awesome in Excel (and your work) in 2012

Published on Jan 6, 2012 in Learn Excel
12 Steps to become awesome in Excel (and your work) in 2012

Obviously, everywhere you look this week, you find advice on how to do better in 2012.

While you don’t have to wait for a new year to become awesome at your work, You might use the occasion.

So, today I want to share 12 ways to become awesome in Excel. But first I have secret to confess…,

I think becoming awesome in Excel useless.

What we really want is, to become awesome in our work. Since we spend a lot of time using Excel (and other office software), knowing how to use these better can have a huge impact on how we do our work.

In that spirit, lets look at 12 steps to become awesome in your work using Excel.

Continue »

Add Data to Charts with Copy Paste [Quick Tip]

Published on Nov 21, 2011 in Charts and Graphs
Add Data to Charts with Copy Paste [Quick Tip]

So how did your weekend go?

I did a bit of gardening, painted our car shed, played badminton (I am learning), attended 60th birthday of a close friend’s dad. Pretty hectic, but fun as usual.

To start this week, let me share a simple but fun way to add data to charts.

Lets say you have a chart that depicts Annual sales for last few years. And you want to add the data of Profits (or Expenses) to this chart. Here is a dead-simple way to do it.

  1. Copy the profit data by selecting it and pressing CTRL+C
  2. Select the chart
  3. Paste by pressing CTRL+V
  4. That is all!
Continue »

Making Small Multiples in Excel [Charting Technique]

Published on Nov 16, 2011 in Charts and Graphs
Making Small Multiples in Excel [Charting Technique]

Today, lets learn how to create small-multiples (or panel charts) to visualize trend of 2 product lines over years in various regions. The inspiration for this chart and article came from my friend, Paresh‘s recent article on his blog.

See how you can create a combination of area & line chart to create the small-multiple chart and clone it. You can also download the workbook and play with it to understand this technique better.

Continue »

Incell Sales Funnel Charts

Published on Sep 29, 2011 in Charts and Graphs
Incell Sales Funnel Charts

Sales Funnel or Sales Process refers to a systematic approach to selling a product or service. [more on sales process] Whether you run a small business or part of a large corporation, chances are, you heard about Sale Funnel. Understanding & analyzing your sales performance from a Funnel point of view is a great way […]

Continue »

Analyzing Performance of Stocks using Excel [Example]

Published on Sep 21, 2011 in Charts and Graphs
Analyzing Performance of Stocks using Excel [Example]

Last week, we learned how to visualize Suicides vs. Murders data using Interactive charts in Excel. William, one of our readers, took this technique and applied it to Stocks. He emailed me because he has some formula issues with the stock data. Once I solved the problem, I asked him, “Can I share this with […]

Continue »

Our VBA Class Registrations Close in Few Hours, Join Now & Learn Excel VBA

Published on Sep 16, 2011 in Training Programs, VBA Macros
Our VBA Class Registrations Close in Few Hours, Join Now & Learn Excel VBA

Hi everyone, I have a quick announcement for you.

Registrations for our VBA class will be closing in a few hours

As you may know, we have re-opened the doors for our VBA Class on September 5th. This program is aimed at beginners & intermediate level users. The aim of our VBA class is to make you awesome in Excel & VBA.

We will be closing registrations for this program in few more hours (exactly at 11:59 PM, Pacific time, on 16th September, 2011)

Click here to join our VBA Class now.

Continue »

Suicides & Murders by US States – An Interactive Excel Chart

Suicides & Murders by US States – An Interactive Excel Chart

Over at PTS Blog, my dear friend & charting guru, Jon Peltier has an interesting post on using dot plots to visualize Murders & Suicides data by US States.

Not that murders & suicides fascinate me, but I wanted to play with this data myself and see how we can visualize it. So I emailed Jon and asked him to share the raw data. Being a lovely chap Jon is, he immediately sent me the data. So here we are, playing with gory data on a Friday.

Suicides & Murders by US States – An Interactive Excel Chart

You can see a demo of the chart I came up with above. Read on to learn how this chart is constructed.

Continue »

Create PowerPoint Presentations Automatically using VBA

Published on Aug 3, 2011 in Charts and Graphs, Excel Howtos, VBA Macros
Create PowerPoint Presentations Automatically using VBA

You’ve been there before. It’s almost 5:00, and you are going crazy trying to finish the presentation due for a monthly performance meeting the next morning. The model is refreshed, and now it just takes a LOT of copying, pasting, and positioning to get the PowerPoint ready. Finally, the slides are finished…, until you read a new message from your boss requesting a minor change. But of course her change means you have to start all over with the copy and pastes…

There is always a better way! In the Oil and Gas industry, I constantly have monthly reports to assess the performance of our operating assets. Excel VBA makes it a cinch to automate the entire process. So when a simple change is requested, the presentation is automatically generated with the click of a button. No more wasting time!

Continue »

Sales Analysis Charts in Excel – 78 Alternatives

Published on Jun 30, 2011 in Charts and Graphs, Excel Challenges, Learn Excel
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.

Continue »

Excel Links – Updates on Singapore Workshop Edition

Published on Jun 27, 2011 in excel links

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.

Continue »

Win Loss Chart from a Series of Win, Loss Data

Published on Jun 15, 2011 in Charts and Graphs
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.

Continue »

How to create a Win-Loss Chart in Excel? [Tutorial & Template]

Published on Jun 9, 2011 in Charts and Graphs
How to create a Win-Loss Chart in Excel? [Tutorial & Template]

Win Loss Charts are an interesting way to show a range of outcomes. Lets say, you have data like this:

win, win, win, loss, loss, win, win, loss, loss, win

The Win Loss chart would look like this:

Win Loss Charts in Excel - Template & Tutorial

Today, we will learn, how to create Win Loss Charts in Excel.

We will learn how to create Win Loss charts using Conditional Formatting and using In-cell Charts.

Continue »

How Would You Visualize Product Sales Data? [Excel Challenges #2]

Published on May 30, 2011 in Charts and Graphs, Excel Challenges
How Would You Visualize Product Sales Data? [Excel Challenges #2]

We have a new Excel Challenge folks!

I know our friends in US are away celebrating Memorial Day weekend. But that should not leave rest of us from fun. So, we have a new Excel Challenge. This time, you need to make a chart, to visualize product sales data.

And what more, one lucky person could get an Amazon Kindle Reading Device (Wi-fi version) by making the chart.

Continue »

VBA Classes Registration Closing in a Few Hours – Join Now!

Published on May 20, 2011 in Charts and Graphs, VBA Macros
VBA Classes Registration Closing in a Few Hours – Join Now!

I have a quick announcement for you.

Registrations for our VBA Class will be closing in a few hours

As you may know, we have opened registrations for our first batch of Online VBA classes on May 9th. This program is aimed at beginners & intermediate level VBA users. The aim of this course is to make you awesome in VBA. We will be closing registrations for this program in few more hours (exactly at 11:59 PM, Pacific time, on 20th May 2011)

Click here to join our VBA Class now.

Continue »

Place Key Information in Golden Triangle on your Reports, Dashboards etc. [Quick Tips]

Published on Apr 29, 2011 in Charts and Graphs
Place Key Information in Golden Triangle on your Reports, Dashboards etc. [Quick Tips]

Today, we will take a detour to world-wide web and learn how we can improve our dashboards, reports, presentations or workbooks by using one of the ideas, called as Golden Triangle.

Continue »