Peltier Tech Charts for Excel Documentation Index

Using Peltier Tech Charts for Excel

This documentation is not yet complete, but work is in progress. If you have any questions not covered here, please contact Peltier Tech.

• Frequently Asked Questions
• End User License Agreement (EULA)
• Version History
• Installation

Chart Types

All charts created by Peltier Tech Charts for Excel are regular Excel charts. After creation, these charts can be resized and reformatted; care should be taken not to damage the customized layout and formatting that give the charts their special appearance. The charts can be copied and pasted just like any other Excel charts: to another worksheet or workbook, or to another program, like Word or PowerPoint. The program is needed only to create the charts; Excel users who do not have the program are still able to view and edit the charts.

Click here to download a workbook with sample data for waterfall charts and other charts in the program.

• Waterfall Charts
  • Waterfall Chart
  • Extended Waterfall Chart
  • Stacked Waterfall Chart
  • Dual Waterfall Chart
  • Rotated Waterfall Chart
  • Split Bar Waterfall Chart
  • Paired Waterfall Chart
• Box and Whisker Charts
  • Box Plot
  • Grouped Box Plot
  • Quartiles for Box Plots (tutorial on Peltier Tech Blog)
• Dot Plots
  • Dot Plot – New Variants
    Dot Plot with Markers, Dot Plot with Lines and Markers, Lollipop Plot, Dumbbell Plot, Bungee Plot
  • Dot Plot – Classic
• Cycle Plots
  • Cycle Plot
  • Convert Chart to Cycle Plot
• Diverging Stacked Bar Chart
• Histogram
• Pareto Diagram
• Clustered-Stacked Column and Bar Chart
• Marimekko Chart
• Cascade Chart
• Step Chart
  • Step Chart
  • Convert to Step Chart
• Layer Chart
  • Layer Chart
  • Convert to Layer Chart
• Slope Chart
• Bullet Chart
• Quick XY Charts

Chart Data

• Edit Series Formulas
• Add Next Series
• Modify Series Data

Chart Format

• Label Last Point
• Match Data Label Colors
• Copy and Paste Series Formats
• Switch X and Y (axes, titles, and/or data)
• Add Error Bars
• Move and Resize Chart Elements
• Unpivot (convert Pivot Chart to regular chart)

Chart Export

• Export Chart as Image File
• Export Range as Image File
• Export Chart to Word and PowerPoint

Data Tools

• Loess Regression
• Clean Data Range

General Tools

• Nice Table Style
• Nice Pivot Table Style
• Open Active Folder

Context Menus

• Chart Title
• Plot Area
• Legend
• Axis

Functions

• User Defined Functions
• Using VBA with Peltier Tech Charts for Excel

Known Issues

• Add-In Disappears from Excel
• Prompt for VB Password
• Error in Loading DLL
• General Excel for Windows Problem Solving

Don’t Have Peltier Tech Charts for Excel?

Get it here: Peltier Tech Charts for Excel.

Contact Peltier Tech

If you encounter a bug, or if you have an idea for a killer feature, contact Peltier Tech and tell us about it. If submitting a bug report, please include your versions of Excel and Windows and the exact error description (since the error numbers may be assigned to many issues), and if possible please provide the data you were using when the bug appeared and any intermediate output of the utility.

About Peltier Tech

Peltier Technical Services offers a variety of useful, easy-to-use, and guaranteed utilities. Peltier Tech offers rapid, personalized customer service in case there are any problems or questions.

All Peltier Tech Chart Utilities are integrated into Microsoft Excel spreadsheet software as standard add-ins for Excel. These utilities provide buttons on the Excel ribbon that allow you to access their features.