Archive for 'General'
Excel Dashboard Training
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2012.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
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 [...]
Posted: Thursday, April 15th, 2010 under General.
Comments: 13
Some Comments on Dot Plots (Guest Post)
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2012.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
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 [...]
Posted: Thursday, April 8th, 2010 under General.
Comments: 24
Looking Back at Peltier Tech in 2009
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2012.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
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 [...]
Posted: Thursday, January 14th, 2010 under General.
Comments: 11
Logarithmic Axes in Excel Charts
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2012.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
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 [...]
Posted: Tuesday, August 25th, 2009 under Formatting, General.
Comments: 4
Context Menu Key
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2012.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
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 [...]
Posted: Thursday, August 20th, 2009 under General.
Comments: 6
Pardon the Interruption
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2012.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
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 [...]
Posted: Friday, July 17th, 2009 under General.
Comments: none




