top of page
Multiple Y Axes for Excel (Multy_Y)

Multy_Y

Multy_Y creates 2 or more Y axes in Excel.
Multiple Y axes plots are created from existing Excel Charts. Each Excel chart appears as a new Y axis on the Multy_Y plot. The plot is a picture that appears on a separate Excel Chart.
 
Note: To create interactive Multiple Y axes plots, EZplot must be purchased instead. Interactive plots allow you to click on the plots and change titles, scales, labels, etc...  There are videos about Multy_Y on the EZplot page.

  • Before Downloading Multy_Y for PC

    Excel must have access to the Visual Basic project.  Before downloading, perform the following steps in your version of Office/Excel:

    • Office/Excel 2007 and higher:
      • Microsoft Office Button -> Excel Options -> Trust Center -> Trust Center Settings -> Macro Settings -> Check Trust access to the VBA project object model
    • Office/Excel 2000-2003:
      • Tools-macro-security -> Trusted Publishers -> Check Allow access to Visual Basic Project

  • Free Demo Version

    Same setup as full version: See Before Downloading section.

    The demo version creates a Multiple Y Axes picture with a watermark.

  • FAQ (Frequently Asked Questions)

    What if I don't see a Multy_Y button (or a Multy_Y button under Addins) at the top of Excel after installation?
    Troubleshooting:
    1. Right click on install exe file and "Run As Administrator."
    2. Make sure that no other addin that you have installed in interfering with the software. Temporarily disable the other addin(s) and install the software.
    3. In newer versions of Office, go to File -> Options -> Customize Ribbon and then make sure Addins is selected. 
    4. Make sure that you have not selected "Disable all Application Add-ins" in the Trust Center Settings for Add-ins in your version of the Office application.
    5. Go to File and see if the Office 365 account says Fix Me (if so, you may need to Sign In or Change License from a temporary email such as email.info). 
    6. See the Setup sheet for Multy_Y in the file: C:\Multy_Y\Multy_Y_Example.xls

     

    What if the Multy_Y button (in Addins) or other functionality does not work?
    Make sure you have an Active license of Office (not all features will work unless you have an active license).  Search online on how to check for your version.

     

    Why do I get the error, "This workbook has lost its VBA project, ActiveX controls and any other programmability-related features"?
    The error occurs because "Visual Basic for Application" was not installed during the software installation. Close Excel. In the Windows Control Panel choose Add or Remove Programs (or Programs and Features in Windows Vista or Windows 7). Select Microsoft Office then Click Change. Select Add or Remove Features then in the Office Shared Features list select Visual Basic for Applications -> Run from My Computer and then Continue. You can then run the software when you reopen Excel.
     
    Where did the software download?
    C:\Multy_Y
     

    Is Multy_Y for Windows or Mac?
    Windows.

     

    Are Office Expander downloads Digitally Signed and timestamped so that I know the files are from Office Expander?
    Yes.
     
    Is an uninstaller included?
    Yes.
     
    Can plots generated with Multy_Y for Excel be viewed on computers without Multy_Y installed?
    Yes. Multy_Y plots can be viewed in Excel, but not changed, on computers without Multy_Y installed.
     
    Can I run Multy_Y as a VBA macro?
    Yes. The following is an example of code that you would put in your macro after you have installed Multy_Y. This example should be copied into the Multy_Y_Example.xls file that is included with the Multy_Y program (or available on the web). Just change the items in blue for your specific example (note that you can add more items if you have more axes).

    Sub Multy_Y_Macro()
    Dim dummy_variable As Variant 
    Dim multyarray As Collection
    Set multyarray = New Collection
    With multyarray