Profile

Cover photo
Jon Peltier
530 followers|83,337 views
AboutPostsPhotosVideos

Stream

Jon Peltier

Shared publicly  - 
 
People have struggled for a long time to find effective means of displaying single points of data. With the recent obsession with dashboard displays of business data, this struggle has come to a head. On one side, there are myriad gauge designs; on the…
This updated tutorial shows a simple approach to making single or multiple horizontal and vertical bullet charts in Excel
1
3
Humberto Cruz's profile photoMacario Hernández Garza's profile photo
Add a comment...

Jon Peltier

Shared publicly  - 
 
Often you want to add custom data labels to your chart. The chart below uses labels from a column of data next to the plotted values. When you first add data labels to a chart, Excel decides what to use for labels—usually the Y values for the plotted…
This tutorial describes a number of ways (manual, built-in, and programmatic) to add custom data labels to an Excel chart.
1
2
Christopher T. Fennell's profile photoMacario Hernández Garza's profile photo
Add a comment...

Jon Peltier

Shared publicly  - 
 
In a recent Mr Excel post, a member asked how to convert a CSV File to Excel File with Dynamic Graphing Capability. This is a great topic for a tutorial, but too long for a forum answer. Problem Statement The simple statement was this: Convert a CSV file…
This tutorial shows development of a VBA program to open a CSV file, save it as an Excel workbook, and let the user select which data to plot.
2
Add a comment...

Jon Peltier

Shared publicly  - 
 
 
How to transfer polygon data into freeform shapes in Microsoft Excel
2 comments on original post
1
Add a comment...

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.
4
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...
Have him in circles
530 people
Tony Ramos's profile photo
christopher boateng's profile photo
Krishna Kumar Natarajan's profile photo
‫جامع التوحيد‬‎'s profile photo
Earl Rigg's profile photo
annie pettit's profile photo
Isma wati's profile photo
Elissa Fink's profile photo
Rory Archibald's profile photo

Jon Peltier

Shared publicly  - 
 
Guest post by Zack Barresse & Kevin Jones Data Automation Professionals, LLC Zack and Kevin are VBA ninjas who have been helping people around the internet for several years. They’ve combined resources and started a company, Data Automation Professionals,…
This tutorial shows how to use Structural Referencing, a new syntax for referring to Tables and parts of Tables in Excel.
1
2
Data Visualization's profile photopaul jakobson's profile photo
Add a comment...

Jon Peltier

Shared publicly  - 
 
Introduction This article builds upon a previous post, VBA: A Simple Tool to Open a CSV File and Create Chart with Data Specified by User, which showed how to build the barest possible VBA procedure for opening a CSV file and making a chart from its data.…
This tutorial shows development of an advanced VBA add-in to open a CSV file, save it as an Excel workbook, and let the user select which data to plot.
2
1
Data Visualization's profile photo
Add a comment...

Jon Peltier

Shared publicly  - 
 
This article was inspired by the Mr Excel forum. A member asked Charts: Any way to make a shape stick to a point in a scatterplot, not an absolute location on the chart? The answer, of course, is Yes, but you have to know the trick, which I’m about to…
1
2
paul jakobson's profile photoData Visualization's profile photo
Add a comment...

Jon Peltier

Shared publicly  - 
 
Recent Colors When you customize a color and apply it to an object in Microsoft Office, the color is stored as part of the Office file, and presented in a “Recent Colors” category on the various colors dropdowns. Up to ten of these custom colors are…
The "Recent Colors" that appear on a Microsoft Office color formatting dropdown are saved in the active document. Here is how to find (and delete) them.
2
1
Data Visualization's profile photo
Add a comment...

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...
People
Have him in circles
530 people
Tony Ramos's profile photo
christopher boateng's profile photo
Krishna Kumar Natarajan's profile photo
‫جامع التوحيد‬‎'s profile photo
Earl Rigg's profile photo
annie pettit's profile photo
Isma wati's profile photo
Elissa Fink's profile photo
Rory Archibald'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