EZplot

Click to watch EZplot Videos:

• Welcome and Background
• Overview
• Basic Plotting 1
• Basic Plotting 2
• Basic Plotting 3
• Basic Plotting Recap
• Calculations
• Multy_Y Plotting
• Chart Changes
• Defaults for Plots
• Plotting
• Contour Plotting
• Curves
• Interp 2D and Interp 3D Functions
• Poly Functions
• Misc.
• Error Handling
• EZplot Toolbar Button

EZplot Training Manual (PowerPoint file download)

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

Same setup as full version: See Before Downloading section.

• Download: EZplot Free Demo Software
• Right click on install exe file and "Run As Administrator."

What if I don't see an EZplot button (or an EZplot 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 EZplot in the file: C:\eZplot_folder\Simple_Plotting_Example.xls

 

What if the EZplot 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:\eZplot_folder.

 

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

 

Where do I go for more information on EZplot?
The eZplot_Training_Manual.ppt has information and examples.  The EZplot Videos also have demonstrations of EZplot.

 

Can I change the scale size on a Multy_Y plot generated with EZplot, or get more room for a plot with multiple Y axes?
Yes. On the eZplot sheet, type xscale or yscale. 
Then set the font size of the text (its own font size) to a desired size - preferably between 8 and 16 (smaller may be better). Then right click and plot.This will give you more room on the plot. You can also do the same thing for ytitle and xtitle to change their font size (and use larger font sizes). 

 

Can Multy_Y plots and Contour Plots be viewed on computers without EZplot installed?
Yes. Any plot generated with EZplot can be viewed in Excel without EZplot installed. However, Multy_Y plots cannot be changed without EZplot installed.

 

Can I run EZplot as a VBA macro?
Yes. The macro code to run EZplot (after EZplot is installed on your computer and an EZplot sheet is created and populated) is: 
dummy_variable = Application.Run("eZplot_1.01.xla! eZplotrun")

 

What if I have trouble generating multiple Y axes plots from the EZplot sheet?
Make sure that you have indicated ymin and ymax for each of the axes. Also pick ydiv or yinc that make sense for the ymin and ymax values used. For example:
ymax 100 1000
ymin 0 0 
ydiv 10 
Not ydiv 11 

 

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 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 if I need more assistance?
Contact us at email: inquiry@OfficeExpander.com