Profile

Cover photo
Jon Peltier
544 followers|89,285 views
AboutPostsPhotosVideos

Stream

Jon Peltier

Shared publicly  - 
 
This is a quick post to answer this rather common question from the forums: I have a worksheet that has data in a particular arrangement and a chart that plots this data. I have another worksheet with the identical data arrangement. How can I copy the…
It's not easy to copy a chart onto a new sheet and have it link to data on the new sheet. Here is an easier way to link the chart to the new data.
3
Add a comment...

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...
In his circles
246 people
Have him in circles
544 people
Jamie Garroch's profile photo
Daniel Ferry's profile photo
Daniel Jarratt's profile photo
Keith Anderson's profile photo
Mynda Treacy's profile photo
Zack Barresse's profile photo
Dan Cory's profile photo
ashfaq ahmad's profile photo
Philip Treacy's profile photo

Jon Peltier

Shared publicly  - 
 
The Paired Waterfall Chart I came across a new (for me) style or waterfall chart last month, which I call the paired waterfall chart. It is designed to show how an investment fund’s total holdings, comprised of stocks or other vehicles and cash, changes…
This article describes the paired waterfall chart, helps you interpret it, and shows how to build it with Peltier Tech software.
3
1
Add a comment...

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...
People
In his circles
246 people
Have him in circles
544 people
Jamie Garroch's profile photo
Daniel Ferry's profile photo
Daniel Jarratt's profile photo
Keith Anderson's profile photo
Mynda Treacy's profile photo
Zack Barresse's profile photo
Dan Cory's profile photo
ashfaq ahmad's profile photo
Philip Treacy'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