All articles with 'user polls' Tag

How long have you been using Excel? [poll]

Published on Feb 11, 2011 in Learn Excel
How long have you been using Excel? [poll]

This week’s poll is dead simple. Just tell me since how many years you are using Excel. I will go first: I have first started using Excel in year 2003 to keep track of my MBA entrance exam preparation. It helped me a lot in recording practice test scores, listing all the mistakes I made […]

Continue »

What is the last visible cell in your excel window? [Poll]

Published on Oct 29, 2010 in Learn Excel
What is the last visible cell in your excel window? [Poll]

This is a fun and quick poll.

I want to know what is the maximum number of cells you can see when you open Excel. Do this:

  1. Open Excel, Maximize the window if it is not.
  2. Just tell me the bottom right cell that you can see completely.
  3. Go have a good weekend :)
Continue »

How do you make charts when you have lots of small values but few extremely large values? [Debate]

Published on Aug 20, 2010 in Charts and Graphs, Featured, Learn Excel
How do you make charts when you have lots of small values but few extremely large values? [Debate]

Here is an interesting charting problem we come across once in a while. We have a lot of small numbers and a few very large numbers. How do we effectively plot all of them in a chart?

Now, how do you go about making a chart?

Continue »

What is the most unusual thing you have used Excel for? [Quick Poll]

Published on Aug 13, 2010 in Featured, Learn Excel
What is the most unusual thing you have used Excel for? [Quick Poll]

Ok. This is quick and short. What is the most weird, unusual, out of the world thing you have used excel for?

I have used excel to generate and clean a list of tags for this blog, to keep track of which movies I have seen in the IMDb Top 250 list, to simulate monopoly board game, just so I can play it better than my wife ;) etc.

What about you? Share using comments.

Continue »

Do You Want to Learn Excel Financial Modeling?

Published on Jul 6, 2010 in Financial Modeling, Learn Excel
Do You Want to Learn Excel Financial Modeling?

Very Quickly, Chandoo.org is partnering with Pristine to start a free course on financial modeling using excel. If you are interested, take this short survey and tell us what topic you want to learn. Back Story One of the advantages of going to a premier MBA college is that you are bound to have good […]

Continue »

Football anyone? [off-topic]

Published on Jul 2, 2010 in Off-topic
Football anyone? [off-topic]

This is rare folks. We have an off-topic thread!!! Since, the next football world-cup is not until next version of Excel and since, I find myself watching a lot of it these days, I thought why not fool around on a Friday with an offtopic discussion?!? So here it goes, what are your favorite teams […]

Continue »

What new chart types you want to see in Excel? [poll]

Published on Jun 18, 2010 in Charts and Graphs
What new chart types you want to see in Excel? [poll]

Hui, one of our in-house excel ninjas at Chandoo.org Forums, has asked an interesting question. Microsoft is already planning the next version of Excel and is looking for our feedback into what extra chart types it should offer/include. [more] It is an interesting question, so lets have a poll. What new chart types you prefer […]

Continue »

What are your favorite colors for charts?

Published on Apr 23, 2010 in Charts and Graphs
What are your favorite colors for charts?

Ok, it is Friday again. That means poll time. I would like to know what color choices you prefer for your charts?
My Favorite Colors for Charting are,

These are the colors I use when making charts in Excel 2007 (it has capability to set any color for chart elements).

Continue »

What do you use Excel for? [Weekend Poll]

Published on Mar 26, 2010 in Learn Excel
What do you use Excel for? [Weekend Poll]

It is Friday again, time for another poll on PHD. This time, we will keep it very simple. I want to know what you use excel for? I use excel for, Preparing dashboards, reports, automation solutions for my clients Making invoices, estimates, plans for my projects Tracking various project activities (bugs, issues, changes, requirements etc.) […]

Continue »

How do you consolidate data from multiple sheets in to one? [open thread]

Published on Feb 19, 2010 in Excel Howtos
How do you consolidate data from multiple sheets in to one? [open thread]

Long time PHD reader and mother of a lovely kid, Michelle, sent me a question in email that provoked me to write this post, I was wondering how to tabulate large amount of information gathered through surveys. Where I work customers are constantly handed survey sheets in order for us to measure how the service […]

Continue »

What is the most useless feature in Excel? [poll]

Published on Feb 12, 2010 in Charts and Graphs
What is the most useless feature in Excel? [poll]

What do you think is the most useless feature in MS Excel? I know there are a ton of cool, extremely useful features in excel. But it also comes with a few really un-necessary features. For me, the most useless feature seems to be a 3D surface chart. I have tried to figure why this […]

Continue »

Best Charts to Compare Actual Values with Targets – What is your take?

Published on Dec 18, 2009 in Charts and Graphs, Featured
Best Charts to Compare Actual Values with Targets – What is your take?

Comparing values is one of the main reasons we make charts. Yesterday we have a post on using thermometer charts to quickly compare actual values with targets. Today we follow up the post with 10 charting ideas you can use to compare actual values with targets. Check out how bullet charts, thermometer charts, traffic lights, gauges, column charts, area charts can help you compare targets with actual performances. A review of best charting options when you need to compare.

Read the rest of the post to see the options and participate in poll.

Continue »

Why do you visit PHD?

Published on Nov 24, 2009 in blogging
Why do you visit PHD?

We interrupt usual routine of excel and charting tutorials to present the first ever readership survey on PHD. In fact, there are so few questions that to call it a survey would be an insult to other surveys, but I digress.

I want you to take few seconds and fill out this very simple form. Just type in whatever comes to your mind, honest and simple stuff. The survey is below, if you are not able to see it in RSS reader or email client, please go to http://bit.ly/phd-survey.

Continue »

What is the most embarrassing charting mistake you made? [weekend poll]

Published on Nov 13, 2009 in Charts and Graphs
What is the most embarrassing charting mistake you made? [weekend poll]

This week’s poll is very simple. What is the the most embarrassing charting mistake your made?

For me it has to be that one time when I made a sports dashboard using excel. I have adjusted the axis scale of a bar chart so that my favorite cricket player (Sachin Tendulkar, who else?)’s records are emphasized. In a matter of minutes I have received several comments from all over world pointing out the mistake. Even though, the intention was to highlight the achievements of master blaster, the axis adjustment was obviously a mistake.

Continue »

Chart this Sales Data and get an iPod Touch [Visualization Challenge #2]

Published on Nov 11, 2009 in Charts and Graphs
Chart this Sales Data and get an iPod Touch [Visualization Challenge #2]

Here is a challenge many people face. How to make a chart visualizing sales data with several dimensions like product, brand, region, sales person name, year (or month or quarter) and one or two values like sales, # of units sold, profits, # of new customers.

In visualization challenge #2, all you have to do is a make a chart or dashboard to visualize this sales data effectively.

Continue »