Office Expander Home
Full Download
Contact Us
FAQ (Frequently Asked Questions)

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.

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.

Are Office Expander downloads Digitally Signed and timestamped so that I know the files are from Office Expander?

>> Yes.

Where did it download?

>> C:\Multy_Y

What if I have trouble installing the software?

>> See the Setup sheet for Multy_Y in the file:  C:\Multy_Y\Multy_Y_Example.xls

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 Sub

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 seeting 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.

Is an uninstaller included?

>> Yes.

Why 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 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.

Where do I go for more information?

>> The Multy_Y_Example.xls file in C:\Multy_Y and the website have information and an example Multy_Y plot.

Why can't I get the program to run?

>> 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.

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.

Contact us if you need more assistance:

© 2001- Office Expander