Profile

Cover photo
Jon Peltier
540 followers|88,750 views
AboutPostsPhotosVideos

Stream

Jon Peltier

Shared publicly  - 
 
Peltier Tech Charts for Excel has been updated to Build 3008, on 11 April 2016. If you are using an earlier build and you want to update to 3008, send me an email. This is not a major upgrade, but it seems like more than a minor one. There are big…
This article describes changes in Peltier Tech Charts for Excel 3.0, Build 3008, 11 April 2016.
2
Add a comment...

Jon Peltier

Shared publicly  - 
 
Excel Summit South 2016 In a little over a week, a half dozen Microsoft Excel MVPs will kick off a series of two day conferences in New Zealand and Australia. These MVPs will join with industry leaders from around the world in leading session on Financial…
1
Add a comment...

Jon Peltier

Shared publicly  - 
 
About Pivot Charts If you select a pivot table and insert a chart, Excel inserts a pivot chart. A pivot chart is a special Excel chart, with some strengths and some limitations. I used to avoid pivot charts because of these limitations, which included not…
Pivot charts are special Excel charts, with some strengths and some limitations. This article shows how to deal with pivot charts and their data and links.
4
Add a comment...

Jon Peltier

Shared publicly  - 
 
What’s a “Technical” Dot Plot? This chart is crisp and well suited for publication in a technical journal, hence the name I’ve given it, “Technical” Dot Plot. The chart below show results of a hypothetical clinical trial, where the X values (categories)…
What’s a “Technical” Dot Plot? This chart is crisp and well suited for publication in a technical journal, hence the name I’ve given it, “Technical” Dot Plot. The chart below show results of a hypothetical clinical trial, where the X values (categories) are three different cleansing approaches, and the Y values are the individual responses, where …
2
1
Add a comment...

Jon Peltier

Shared publicly  - 
 
Hello patient followers. I haven’t posted for a while, not because I can’t think of anything to write about, but because I’ve been rather busy. I’ll talk about each of these things separately, but I think I need a quick post to say what’s going on.…
1
1
Add a comment...

Jon Peltier

Shared publicly  - 
 
Peltier Technical Services is pleased to announce the newest version of its landmark charting utility. You can skip this article and go straight to Peltier Tech Charts for Excel 3.0 to license your copy. From now until September 30, the 30th anniversary…
Peltier Technical Services announces its latest, Peltier Tech Charts for Excel 3.0. This article describes new features and links to the licensing page.
3
1
Beck Chan's profile photo
 
excellent
Add a comment...
In his circles
246 people
Have him in circles
540 people
Zack Barresse's profile photo
Ken Puls's profile photo
Victor Román Castro's profile photo
ashfaq ahmad's profile photo
Elissa Fink's profile photo
Zeljko Borojevic's profile photo
Eko Sastra's profile photo
Mary Pat Campbell's profile photo
Masaru Kaji's profile photo

Jon Peltier

Shared publicly  - 
 
Last month I and several of my colleagues descended on New Zealand and Australia for Excel Summit South 2016. This was a series of two-day Summit conferences, one each in Auckland, Sydney, and Melbourne. The Conference The first thing I have to say is…
Last month I and some of my colleagues visited New Zealand and Australia for Excel Summit South 2016: 2-day conferences in Auckland, Sydney, and Melbourne.
1
Add a comment...

Jon Peltier

Shared publicly  - 
 
Combination charts combine data using more than one chart type, for example columns and a line. Building a combination chart in Excel is usually pretty easy. But if one series type is horizontal bars, then combining this with another type can be tricky.…
2
Add a comment...

Jon Peltier

Shared publicly  - 
 
A reader emailed to ask whether you could make a dynamic chart using OFFSET-function-based Names in Excel 2016 for Mac. Good question, and I wondered if he’d encountered some unexpected problem, perhaps a bug, in Mac Excel. So I dusted off my MacBook Pro…
This tutorial shows a couple ways to make dynamic charts in Excel 2016 for Mac and for all Windows and Mac versions of Excel.
1
Add a comment...

Jon Peltier

Shared publicly  - 
 
The xkcd Velociraptor Problem #1 In Substitute, we learn of a substitute teacher’s “real-life” math problems, which include the following: Ha, ha, funny commentary on a frustrated old substitute math teacher. (Disclosure: my wife is an 8th grade math…
The xkcd Velociraptor Problem #1 In Substitute, we learn of a substitute teacher’s “real-life” math problems, which include the following: Ha, ha, funny commentary on a frustrated old substitute math teacher. (Disclosure: my wife is an 8th grade math teacher, and frustrated is often descriptive of her job.) So how far could you get before …
1
Add a comment...

Jon Peltier

Shared publicly  - 
 
Today Microsoft officially releases Office 2016 for Windows. We’ve been able to preview it for some time, of course, and the Mac version has been out for a few weeks. But now it’s been let loose. I have not personally devoted a lot of time with the…
3
2
Beck Chan's profile photo
 
excellent
Add a comment...

Jon Peltier

Shared publicly  - 
 
In Stacked column chart in Excel with the label of x-axis between the bars, a SuperUser user posted this chart, asking how to get the labels between the columns, instead of under the columns, where Excel puts them. This is a great tutorial, so I’m…
This quick tutorial shows how to use a hidden XY series to provide custom labels where desired along a chart's axis.
1
1
Add a comment...
People
In his circles
246 people
Have him in circles
540 people
Zack Barresse's profile photo
Ken Puls's profile photo
Victor Román Castro's profile photo
ashfaq ahmad's profile photo
Elissa Fink's profile photo
Zeljko Borojevic's profile photo
Eko Sastra's profile photo
Mary Pat Campbell's profile photo
Masaru Kaji's profile photo
Collections Jon is following
Basic Information
Gender
Male
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.
Work
Occupation
Developer