EZplot for Excel

EZplot

EZplot's unique capabilities for Excel:

  • Generates over 50 plots in seconds
  • Creates Multiple Y axes plots (unique software for Excel)
  • Creates real Contour plots (unique software for Excel)
  • Uses parameter names instead of cells to select data
  • Eliminates need to remember any commands by using built-in right-click menus
  • Captures changes made to Excel charts and automatically generates a plot script
  • Operates in the familiar Excel environment
  • Performs data calculations easily
  • 2D and 3D interpolation formulas right in Excel
  • Improves productivity, decreases effort!

 

EZplot is a plotting and data calculation tool to enhance Excel. The EZplot Excel add-in improves productivity by easily creating many plots in seconds. Plots are defined with parameter names instead of requiring manual selection of data. The user does not need to remember any commands because of a carefully laid out user interface, which includes fonts, colors, scales, divisions, trendlines, sets etc...

  • Before Downloading EZplot 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.

  • FAQ (Frequently Asked Questions)

    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

     

    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

     

$69.99 Regular Price
$29.99Sale Price

©2020 by Office Expander.