Excel Charting and Dashboarding Westborough MA, June 2 Jon Peltier (Peltier Technical Services) and Alex Kerin (Data Driven Consulting) have put together an intensive one-day Excel Charting and Dashboarding session. Topics include: Intentions and approaches Data quality Effective graphic techniques Designing a dashboard Combination charts Dynamic and interactive charts Advanced chart formatting Charting and dashboard [...]

I recently posted about Stacked Bar Chart Alternatives and included some rather cluttered charts with markers and lines, which I referred to as “Dot Plots”. I was called to task by none other than Naomi Robbins, author, researcher, consultant, and renowned expert in the field of data presentation graphics. Briefly, Naomi recoiled at the thought [...]

I wrote a post last month called State of the Blog – Year End 2009, but that was more of a “looking forward to 2010″ kind of post, with all the great stuff I want to do. I thought since I was reviewing my site statistics anyway, I’d share some of it. In 2009, I [...]

In Custom Axis, Y = 1, 2, 4, 8, 16 I showed axes with base 2 logarithmic scales in both Excel 2003 and 2007. In Excel 2003 it is necessary to transform the data to get the intended result. In Excel 2007, the axis can be achieved with the untransformed data. In the previous post, the [...]

One of the best usability features in Microsoft Windows is the context menu, also known as the right-click menu. That’s the menu that pops up under the cursor when you right click the mouse, and it shows what actions are available for the object you’ve right-clicked on. It’s a great shortcut to these actions, and [...]

I’ve had an unintentional holiday from posting, partly due to overloading with client work, and partly due to continued fixing up of my New Computer. It’s usually fun and exciting to get a new computer, but when you have to do most of the setup without access to your old computer, it takes much longer [...]