All articles with 'user polls' Tag
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 »
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:
- Open Excel, Maximize the window if it is not.
- Just tell me the bottom right cell that you can see completely.
- Go have a good weekend
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 »
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 »
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 »
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 »
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 »
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 »
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 »
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 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 »
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 »
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 »
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 »
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 »