Peltier Tech Charts for Excel 4.0

Friday, November 27, 2020 by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2023, All rights reserved.
 

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.

Add to Cart

Check your shopping cart with this button.

View Cart

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.

Peltier Tech Charts for Excel 4.0 Custom Ribbon

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.

Peltier Tech Custom Charts

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
    • Standard Waterfall
    • Extended Waterfall
    • Stacked Waterfall
    • Rotated Waterfall
    • Dual Waterfall
    • Split Bar Waterfall
    • Paired Waterfall
  • Box and Whisker Charts
    • Box Plot
    • Grouped Box Plot
  • Dot Plot Variations
    • Dot Plot
    • Dot Plot with Lines
    • Lollipop Plot
    • Dumbbell Plot
    • Bungee Plot
    • Dot Plot (“Classic”)
  • 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

Peltier Tech 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

Peltier Tech 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

Peltier Tech Export Functions

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

Peltier Tech Data and General Functions

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.

Add to Cart

Check your shopping cart with this button.

View Cart

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.

Volume discounts on Peltier Tech software.

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.

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Tumblr (Opens in new window)
  • Click to share on Pinterest (Opens in new window)
  • Click to share on Reddit (Opens in new window)
  • Click to print (Opens in new window)
  • Click to email a link to a friend (Opens in new window)

Posted: Friday, November 27th, 2020 under .
Tags: .
Comments: none

Peltier Tech Charts for Excel

Microsoft MVP Logo

Peltier Technical Services, Inc. Copyright © 2023 – All rights reserved.

Admin