Peltier Tech has been busy upgrading the powerful Charts for Excel add-in. There are more custom chart types and functions available, and existing features have been enhanced. Read about it below.
If you are a user of an earlier version of Peltier Tech Charts for Excel, contact Peltier Tech for a coupon code so you can upgrade to version 4.0 at a discount.
Excel has some great charts and chart editing features, but there is room for improvement. Peltier Tech Charts for Excel 4.0 is the latest in this outstanding utility that extends Excel’s charting capabilities.
Need a chart that’s not native to Excel? Peltier Tech makes Cycle Plots, Step Charts, Clustered AND Stacked Column or Bar Charts, and more.
Need a better version of a native Excel chart? Peltier Tech has several types of Waterfall Chart, plus Box Plots, Histograms, and Pareto Charts, all of which outperform Excel’s versions.
Need more powerful chart formatting and data editing capabilitites? This is the tool for you.
Get Peltier Tech Charts for Excel Here
Peltier Tech Charts for Excel 4.0 is available for $99. Click this button to make your purchase, or scroll down to read about its features.
Check your shopping cart with this button.
General Features
Peltier Tech Charts for Excel 4.0…
- Works in Microsoft 365 (Office 365) on Windows and Mac computers.
- Also works in Excel 2019, 2016, and 2013 in Windows.
- Also works in Excel 2019 and 2016 on a Mac.
- Integrates into Microsoft Excel as a standard VBA add-in.
- Includes about two dozen custom chart types.
- Creates complex charts in a few simple steps using intuitive dialogs.
- No programming or formula skills needed, no complicated instructions to follow.
- Easy to install.
- Adds a custom tab to the Excel Ribbon.
- Easily access this functionality from your own VBA programs.
List of Features
The custom ribbon for Peltier Tech Charts for Excel 4.0 is shown below. Click on the image to view it at full resolution.
The various sections of the ribbon are shown and described below.
Custom Charts
Peltier Tech Charts for Excel 4.0 includes about two dozen custom chart types. The charts are regular Excel charts, which make use of custom formatting and specialized data layouts. As regular Excel charts, you can copy and paste them, resize them, and move them wherever you like. You can further customize the finished charts with your own colors, fonts, and other formatting.
Several of the buttons offer the option to convert a regular chart (a line or column chart, for example) into a custom chart. This feature is available for Cycle Plots, Step Charts, and Layer Charts.
The custom charts are listed below. Click on a link to see an example of a specific chart type.
- Waterfall Charts
- Box and Whisker Charts
- Dot Plot Variations
- Cycle Plot
- Diverging Stacked Bars
- Histogram
- Pareto Chart
- Cluster Stack Column and Bar Charts
- Marimekko
- Cascade
- Step Chart
- Layer Chart
- Slope Chart
- Bullet Chart
- Quick XY Charts
Chart Data Management
Edit Series Formulas – a find and replace function for chart series formulas.
Add Next Series – add a series to the chart using the next row or column after the selected series.
Modify Series Data – view and modify some or all series in a chart from one detailed dialog.
Chart Formatting
Label Last Point – to make identifying data easier than using a legend.
Match Label Colors – so label text matches the series colors.
Copy/Paste Series Formats – copy formatting from one series to another, even in a different chart.
Switch X and Y – switch the X and Y values in one or more series, or switch the axis titles and scales, or both.
Error Bars – an easier custom error bar dialog than Excel’s.
Arrow Keys to Move/Resize – move or resize elements in your chart with keyboard arrow keys.
Unpivot Pivot Chart – convert a pivot chart to a regular chart while maintaining links to the pivot table data.
Properties Follow Chart Data Point – toggle this obscure property so changing the chart links won’t remove your custom formatting.
Chart Exporting
Export Chart to Image File – export one or more charts as image files.
Export Range to Image File – export a selected range as an image file.
Export Chart to PowerPoint – export one or more charts to PowerPoint.
Export Chart to Word – export one or more charts to Word.
Export features are only available for Windows, not Mac.
Other Features
Loess Regression – smooth data using a moving linear or quadratic weighted regression.
Clean Formats – remove all formatting except number formatting from a selected range.
Nice Table Style – apply a lightweight gray style to a Table, rather than an oversaturated built-in style.
Nice Pivot Table Style – apply a lightweight gray style to a Pivot Table, rather than an overly colorful built-in style.
Open Parent Folder – open the Windows folder that contains the active workbook.
Documentation
Here are a few links to documentation for Peltier Tech Charts for Excel.
- Documentation Index
- Installing the Utility
- Frequently Asked Questions
- Version History – email Peltier Tech to get an up-to-date version
Click Below to Get Peltier Tech Charts for Excel
Peltier Tech Charts for Excel 4.0 is available for $99. Click this button to make your purchase, or scroll down to read about its features.
Check your shopping cart with this button.
License
Each user of Peltier Tech Charts for Excel 4.0 requires a license. Each license allows the user to install Charts for Excel on up to two computers of which they are the primary user. If a user gets a new computer, the software can be uninstalled from the old machine and reinstalled onto the new one.
Discounts for Existing Users
If you are already a Peltier Tech customer, you qualify for a 50% discount when you upgrade to Peltier Tech Charts for Excel 4.0.
Contact Peltier Tech and request a coupon code to apply at checkout, or email Peltier Tech after your purchase at the regular price to request a partial refund.
Bulk Discount
If you purchase multiple licenses, you qualify for a volume discount, shown in the table below. The discount is automatically applied in the shopping cart when you enter your quantity.
Purchase Orders
Peltier Tech will accept purchase orders for orders of $500 or more.
Money Back Guarantee
Like all of Peltier Tech’s software products, Peltier Tech Charts for Excel 4.0 is guaranteed for 90 days from the date of purchase. If you are unsatisfied for any reason, contact Peltier Tech directly to request a refund. Any feedback is appreciated, but none is necessary.
The Purchase Process is Quick and Easy
When your payment is approved, you will be directed to a web page with a download link. You will also receive an email from Peltier Technical Services (jon@peltiertech.com) with a link to a download page. If you do not receive this email, check that it has not been filtered out as spam, then contact Peltier Tech.
The Utility is Downloaded as a Zip File
To account for possible connection problems, the download link remains valid for a period of 5 days or for up to 5 downloads, whichever comes first. If you need to download the utility after this, contact Peltier Tech to obtain a new link.
Note that the five allowed download attempts does not entitle the licensee to install the software on five computers. The standard license requires one purchased license per user, and a user is allowed to install the software on two computers.
If you have problems with the download or installation, please contact Peltier Technical Services.
Installation
Peltier Tech Charts for Excel 4.0 is an Excel VBA add-in, which can be installed in Excel for Windows or Excel for Mac. Follow instructions at Installing Peltier Tech Charts for Excel or Install an Excel Add-In, and you’ll be working in no time.
Resellers
Please read the Resellers page.
Questions?
Contact Peltier Tech with any questions about Peltier Tech Charts for Excel 4.0.