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

>> On some computers, access to the Visual Basic project will have to be set in Excel by: Tools-macro-security  -> Trusted Publishers -> Check Allow access to  Visual Basic Project. Then close Excel and reopen.

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
Dim basename As String

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

basename = "Multy_Y Plot"

dummy_variable = Application.Run("Multy_Y.xla! multy_y_macro", multyarray, basename)
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.

Why am I getting an error?

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

Where do I go for more information?

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

Contact us if you need more assistance: inquiry@officeexpander.com