-
Today’s post was written by Excel MVP Nate Oliver. Excel 2010 presents traditional numerical analysts with new and old tools; today we’ll explore two of them. The difference is that the first shall be what we call qualitative, and the second, quantitative. As a real-world example, on a really hot day...
-
TM AutoChart is a shareware Excel add-in that links the minimum, maximum, major, and minor values of a chart axis to worksheet cells. http://www.tushar-mehta.com/excel/software/autochart/index.html Over the past few months I have been trying out different Ribbon layouts for chart related add-ins. For...
-
Debra sez:
If you want to make your Excel charts look like they were made in 2010, instead of 1982, see the Excel Charting tutorials on Jon Peltier’s blog.
However, if you feel like kicking it old skool… Problems:
I couldn’t read the title and y-axis, so I took a stab.
I don’t know...
-
I was watching a DVR’d episode of House recently and I became aware that the amount of show between commercials was changing as the show went on. The commercials were getting closer together. Then at the end, a long run of show between the last commercial and the credits. I did what [...] Read...
-
Thanks to Dan Battagin for writing this blog post. OK, so I'm sure everyone knows about the Freeze Panes feature in Excel - it's been around forever, and it's pretty useful in certain circumstances where you want to keep a row (or more) of data at the top of the sheet, or column on the side...
-
Rob over at http://powerpivotpro.com has a interesting post on scatter charts and PowerPivot: At right is a list of all chart types in Excel. But not all of them are supported as PivotCharts. Try to use XY (Scatter), Bubble, or Stock as a PivotChart, and you’ll get an alert saying you cannot create it...
-
Because I have no clue. It’s from an university alumni magazine. The names I’ve smudged (or tried to anyways) are the various colleges. Could this graphic be done in Excel? Yes. Should it? Read More...
-
When Excel creates a chart it assigns, by default, certain physical dimensions to the chart. These physical dimensions (height and width) are independent of the logical content of the chart. So, in the case of a column chart the physical shape of the chart is the same irrespective of whether it contains...
-
Overview In Excel 2007, the ability to directly resize or reposition points on the chart was deprecated. This feature was sometimes referred to as "Graphical Goal Seek." For example, in Excel 2003 a user could click on a data point in a column chart twice which would surface handles that could...
-
Everyone is sick of talking about how pie charts suck. And whenever I do a charting post, it’s trouble. So this post is destined for failure. However, I was thinking about pie charts recently. I don’t have the disdain for pie charts that some do, but I generally agree with the [...] Read...
-
I’m back from my vacation (boy, Seattle is really gorgeous during the summer!). Thanks to Sam Radakovitz (Sam Rad) for filling in for me while I was out. And thanks to Ben Rampson and Robin Wakefield for putting together this final post on charting improvements in Excel 2010. In this post I’ll walk through...
-
Peter King at SI says:
The NFL has a slotting system that is ever-so-slightly malleable, where a player who gets drafted one spot lower than another player occasionally gets a smidgeon of a better deal. And sometimes a quarterback gets an above-market deal. But position players and non-quarterback skill...
-
Thanks to Ben Rampson for putting this post together. In today’s article I will outline some of the significant new chart improvements that impact performance. In Office 2007 the graphics engine used by Office Charts was replaced with one that could support more complex rendering. A downside of this...
-
Inspired by Dick’s interest in charts, I took a look at how I would have presented the data.
Some overall thoughts. I used Office 2010 beta for the charts shown below. There was not much, if any, difference between what I would have got with Excel 2007. I also stayed with the default [...] Read...
-
After week 8 of my golf league, I decided to have a chart-of-the-week. Now, for the first time ever, you can view all the charts o’ the week in one place with author commentary.
Week 8
After scoring week 8, I noted that I was plummeting down the leaderboard while Miller seemed to be scoring well...