Excel's built-in plotting capability can only create one left-right axis per plot. Office Expander's Multy_Y is an add-in for Microsoft Excel that creates multiple Y axes on the left side of plots using existing Excel charts. Each Excel chart appears as a new Y axis on the selected Multy_Y plot, whereas the plot itself is depicted on a separate Excel chart. It can generate automatically formatted plots from XY-scatter plots. You can plot time factors on the X axis of Multy_Y's plots, too. The fully customizable plots created with Multy_Y will display in any Excel edition, not just those that have the add-in.
When you download and install Multy_Y, Excel opens with a sample generated plot, but the program advises checking the Setup sheet for additional information that may be necessary to run it, such as ensuring trusted access to the Visual Basic Project in Excel's Tools menu. Once the add-in has been properly installed, the Multy_Y button appears on the Excel file menu. Clicking it calls up a simple dialog for creating new plots. Multy_Y needs at least two Excel charts to create a plot, but the dialog includes three samples to choose from. Multy_Y plotted the sample numeric data, combining air, velocity, and sensor data, including time data, in a clear display. Creating charts from other data is just as easy; the program lists all available charts in the Excel workbook, and you simply select those you want to plot. There's an Information tab that does a good job of explaining the basics, but this is an easy-to-use tool. Multy_Y is compatible with the developer's EZplot package, which bundles Multy_Y and other tools.
If you regularly need to plot data from several sources in a single chart for clarity or comparison, now you can use the familiar Excel interface instead of a complex, expensive standalone plotting tool, thanks to Multy_Y.
Editors' note: This is a review of the full version of Multy_Y 1.01. The trial version has a watermark on output.
Multiple Y axes plots can be created in Microsoft Excel. Use your existing Microsoft Excel charts to create a multiple Y axes picture plot (for Excel 2000 to 2010). Multy_Y is also available in EZplot so that you can create and interact with Multy_Y plots.
What's new in this version:
Version 1.01 3_22_2014 may include unspecified updates, enhancements, or bug fixes.