Profile

Cover photo
Jon Peltier
532 followers|82,828 views
AboutPostsPhotosVideos

Stream

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.
3
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.
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...
Have him in circles
532 people
Ferenc Valent's profile photo
Carmenitha Enytha's profile photo
Carlos Scheidegger's profile photo
Darren Evans's profile photo
Greg Felt's profile photo
Okengo DENIS AWOK's profile photo
Piorello Rimando's profile photo
Nick Hodge's profile photo
Jackie XL's profile photo

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...

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...
People
Have him in circles
532 people
Ferenc Valent's profile photo
Carmenitha Enytha's profile photo
Carlos Scheidegger's profile photo
Darren Evans's profile photo
Greg Felt's profile photo
Okengo DENIS AWOK's profile photo
Piorello Rimando's profile photo
Nick Hodge's profile photo
Jackie XL'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