Profile cover photo
Profile photo
Jon Peltier
550 followers
550 followers
About
Jon's interests
View all
Jon's posts

Post has attachment
My colleague Patrica McCarthy, the Excel Diva, wrote in 12 Months Data – 13 Months Data in a Chart last week about a problem with Excel charts. If you make a 12-month chart, as you shrink the chart, for example to fit it into a dashboard, Excel drops off…

Post has attachment
Microsoft is conducting a survey to help plan new charting features for future versions of Excel. This is your chance to provide your thoughts and feedback. Here is the announcement from the Excel Team: This survey is being conducted by the Microsoft…

Post has attachment
The VB Password Prompt Problem The VB Password Prompt is a (usually) rare problem that occurs when you are using a workbook or add-in with a password protected Visual Basic project. When you quit Excel, you are asked for a password to open the VB project.…

Post has attachment
I recently showed several ways to display Multiple Series in One Excel Chart. The current article describes a special case of this, in which the X values are dates. Displaying multiple time series in an Excel chart is not difficult if all the series use…

Post has attachment
A common question in online forums is “How can I show multiple series in one Excel chart?” It’s really not too hard to do, but for someone unfamiliar with charts in Excel, it isn’t totally obvious. I’m going to show a couple ways to handle this. I’ll show…

Post has attachment
Often stacked bar charts are used to show the frequency of responses in surveys, where each stack represents the frequencies of replies to a given question (replies often sorted, such as Strongly Disagree, Disagree, Agree, Strongly Agree). A variation on…

Post has attachment
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…

Post has attachment
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…

Post has attachment
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…

Post has attachment
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…
Wait while more posts are being loaded