All articles with 'user polls' Tag
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 »
This week’s poll is quite simple. Tell us what buttons/ icons you have added to the quick launch bar in excel 2007 (or toolbar in excel 2003)?
As for me, I have these in my home laptop’s excel:
Just use the comments and tell me about your settings.Continue »
We talk alot about making better charts and perils of bad charts here.
I want to know what you usually do when a co-worker or boss makes an ugly chart?
- You tell them the chart sucks
- You gently point out the mistakes of their chart and tell them some nicer and cooler ways to tackle it
- You stay calm and send them an e-mail later (may be with a link to PHD chart pages or something like that)
- You don’t care (and may be continue doodling)
- Any other
Vote your option using comments.Continue »