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
- Office/Excel 2007 and higher:
Free Demo Version
Same setup as full version: See Before Downloading section.
- Download: Multy_Y Demo Version
- Right click on install exe file and "Run As Administrator."
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:- Right click on install exe file and "Run As Administrator."
- 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.
- In newer versions of Office, go to File -> Options -> Customize Ribbon and then make sure Addins is selected.
- 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.
- 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).
- 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_YIs 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
.Add Item:="Excel_Chart_1"
.Add Item:="Excel_Chart_2" 'must have at least 2 charts
.Add Item:="Excel_Chart_3"
End With
dummy_variable = Application.Run("Multy_Y.xla! start_multy_manual", multyarray)
End SubWhy does my Multy_Y chart appear to generate with a double image?This could be due to the decimal place used in different regional settings or other factors. Try going to your data sheet, selecting all your data, then right-click and select Format Cells, and select General. Then try to regenerate the chart. (Using a Number Format with decimal places could cause an issue for non-U.S. regional settings where the period is not used as the decimal place.)What if a multiple Y axis won't generate or there is an error?Make sure that the Y axis min, max, and increment is set so that all the labels can fit in a vertical orientation along the Multy_Y axis. For example, if you are using Y axis values from 1,000,000 to 41,000,000 in increments of 5,000,000, then we would not expect it to work (since there is no room for all the numbers written vertically). But if the increment is 10,000,000, then it might just work (or you could divide all numbers by 1000, and list the Y axis label as being in "thousands"). It basically comes down choosing a reasonable for a scale when the numbers are written vertically.What type of Excel chart can Multy_Plots be made from?Multy_Y plots can be made from XY-scatter plots. To change from other Excel chart types, go to the chart, right-click and select:Chart-Type -> Select XY scatter on the left, and then select the scatter plot (with or without lines). Charts generated with EZplot will automatically be generated in the correct format. EZplot will also give you easier control as to how the plots look.Can time be plotted on the X-axis of Multy_Y plots?Yes.Why can't I select my charts on the Multy_Y menu?Charts must each be on a separate sheet (really a chart), not embedded in an Excel worksheet. Right click on each embedded chart, select Location, and then save each chart as a separate sheet (really a chart). Or use EZplot to generate charts and Multy_Y charts all at once.How do I change the colors of each Multy_Y axis?On your original charts, change the symbol or line colors. Do not use automatic colors since they appear the same on the Multy_Y plot. Manually change each color.What is the best screen setting?A screen setting of at least 1024 by 768 is suggested but not required. To change your screen setting, right click on the desktop --> properties --> setting --> screen area 1024 by 768.What types of Excel charts can be used to create Multy_Y plots?Make sure that all of your charts are XY Scatter charts. To do this right-click on your original charts and select Chart Type-->XY Scatter.What if I need more assistance?
Contact us at email: inquiry@OfficeExpander.com