Profile

Cover photo
Jon Peltier
516 followers|81,705 views
AboutPostsPhotosVideos

Stream

Jon Peltier

Shared publicly  - 
 
The Problem A member of the MrExcel forum wanted to know about using form controls to select columns from a data table to populate a graph. Essentially he wanted his users to be able to choose between two charts, one comparing their scores to district and…
This tutorial shows how to let a user control the displayed data in a chart using option buttons in the worksheet.
5
3
paul jakobson's profile photowww.exceltricks.de's profile photo
Add a comment...

Jon Peltier

Shared publicly  - 
 
I haven’t posted in quite a while. I have a few long tutorials that I’m working on, but there hasn’t been enough uninterrupted time to get them done. I’ve also been working on a new edition of my Chart Utility which will run in PowerPoint. This will allow…
Usually, secondary axes are confusing and cognitively butrdensome. But this tutorial shows how a secondary axis with percentages can be a good thing.
4
1
Data Visualization's profile photo
Add a comment...

Jon Peltier

Shared publicly  - 
 
Polar Plots Microsoft Excel offers a number of circular charts, but none of them is usually a particularly good choice for displaying data. You can search this blog for “pie chart” and see numerous examples of badly applied pie charts. If you hunt for…
Polar Plots are not native to Excel. This tutorial shows how to build one using a relatively simple combination of Donut and XY Scatter chart types.
2
1
Data Visualization's profile photo
Add a comment...

Jon Peltier

Shared publicly  - 
 
After using Excel 2007 for a while, getting used to the idea that everything had changed and we weren’t going back to 2003 ever again, I started fooling around with charts and chart elements. I began to find lots of little changes, most of them actually…
Excel 2007 introduced error bars that you could format as AutoShapes. But the arrows at the ends of the error bars weren't working ideally until Excel 2013.
4
David Gerbino's profile photo
 
Thanks +Jon Peltier for doing what you do.
Add a comment...

Jon Peltier

Shared publicly  - 
 
This introduction has been contributed by Debra Dalgleish, Excel MVP. Contextures, Copyright © 2014. All rights reserved. Debra Dalgleish, Excel MVP since 2001, is the author of three books on pivot tables, published by Apress. She shares Excel tips,…
This guest post by Excel MVP Debra Dalgleish is a brief introduction to using Pivot Tables in Microsoft Excel.
6
2
Chris Hanson's profile photoJon Boeckenstedt's profile photoroberto mensa's profile photo
 
This is great, I was just searching earlier today for an introduction to pivot tables for a colleague. Debra's site has been my go-to spot for pivot table video for a few years.
Add a comment...

Jon Peltier

Shared publicly  - 
 
A reader of the Peltier Tech Blog asked me about Swimmer Plots. The first chart below is taken from “Swimmer Plot: Tell a Graphical Story of Your Time to Response Data Using PROC SGPLOT (pdf)“, by Stacey Phillips, via Swimmer Plot by Sanjay Matange on the…
1
Marcos Yepes's profile photoJon Peltier's profile photo
2 comments
 
My hosting company had a major catastrophe Thursday, and I've been down now for nearly three whole days. Making me crazy, I feel like I'm losing money and credibility.
Add a comment...
In his circles
249 people
Have him in circles
516 people
Greg Felt's profile photo
www.exceltricks.de's profile photo
Meni Porat's profile photo
Tim Warris's profile photo
MingHong ly's profile photo
Andy Cotgreave's profile photo
John Clark's profile photo
Ferenc Valent's profile photo
Enrico Bertini's profile photo

Jon Peltier

Shared publicly  - 
 
Floating bars can be used to plot many types of data sets. (“Bars” in this usage means “bars”, as Excel calls horizontally oriented bars, as well as “columns”, as Excel calls vertically oriented bars.) In a waterfall chart, floating bars (usually…
Floating bars are used in many types of charts, such as waterfall charts and Gantt charts. Here are the many ways Excel provides to make floating bars.
2
2
paul jakobson's profile photoData Visualization's profile photo
Add a comment...

Jon Peltier

Shared publicly  - 
 
Plotting Part of a Data Range Excel is pretty handy for collecting, analyzing, and charting lots of data. If you want to plot a subset of your data, you can manually adjust the data range used by the chart. But there are easier ways to select partial data…
This tutorial shows how to use Names to define partial ranges for plotting, which is much easier than manually editing the data source.
2
1
Data Visualization's profile photo
Add a comment...

Jon Peltier

Shared publicly  - 
 
Chart Events When you use a computer, you continuously interact with objects and programs, through events. An event is anything that happens, such as moving the mouse, clicking on objects, changing data, or activating windows. Programs can raise events of…
When using a computer, you continuously interact with objects and programs through events. Here is how to use Chart Events to enhance your workbooks.
4
1
Data Visualization with Tableau's profile photo
Add a comment...

Jon Peltier

Shared publicly  - 
 
This introduction has been contributed by Debra Dalgleish, Excel MVP.  Contextures, Copyright © 2014. All rights reserved. Debra Dalgleish, Excel MVP since 2001, is the author of three books on pivot tables, published by Apress. She shares Excel tips,…
3
1
roberto mensa's profile photo
Add a comment...
 
Hey J Walk, still using Engine Hosting? I've been with them a few years, but I've been looking for a hosting company with more WordPress chops. Than last week a lot of their virtual servers running some legacy virtualization code went belly up, and my site was down for 3.5 days.
1
Jon Peltier's profile photoJohn Walkenbach's profile photo
3 comments
 
Good luck. It seems like a massive project.
Add a comment...

Jon Peltier

Shared publicly  - 
 
Hilarious review.
1
1
matt manks's profile photo
Add a comment...
People
In his circles
249 people
Have him in circles
516 people
Greg Felt's profile photo
www.exceltricks.de's profile photo
Meni Porat's profile photo
Tim Warris's profile photo
MingHong ly's profile photo
Andy Cotgreave's profile photo
John Clark's profile photo
Ferenc Valent's profile photo
Enrico Bertini's profile photo
Work
Occupation
Developer
Story
Introduction
I am a metallurgist by training, with a doctorate degree and over 20 years experience in research and development, manufacturing, and production, in the aerospace, automotive, and industrial parts industries. My background includes Statistics, Total Quality, and Six Sigma.

I started using Excel  as part of my job: doing research, analyzing data, and writing reports. But I soon became obsessed with all things Excel, first with formulas, then with VBA, and finally with charts. I was nominated as a Microsoft Excel MVP in 2001, and renominated every year since.

It turns out that my Excel expertise is in great demand, so for the past five years I've been running my own company, Peltier Technical Services. The company web site and my blog comprise a huge library of Excel and charting tutorials. I work on custom applications for various clients, and I've begun marketing small Excel utilities that do charting things that Excel should but doesn't.
Basic Information
Gender
Male
Apps with Google+ Sign-in