Advanced Graphs

Excel advanced graphs for manufacturing and engineering

Submit Excel Solution
Submit Solution [Guide]

Recently Added:
Tools Add-ins
Data Tools
Directory Contents Lister
Business Intelligence Dashboards
Automation Add-ins
More Resources:
Excel Help Forum




Follow Business Spreadsheets On:
 
Find Excel Solutions:
Suggested text load results and icon loads solution.
Browse Main Categories: Business Finance | Financial Markets | Operations Management | Excel Productivity

Advanced Graphs

Rate this solution:
(3/5 from 2 votes)
DownloadBuy Now
Advanced Graphs screenshot
Pin It
 Advanced Graphs for Excel (DPlot) is a comprehensive application with an Excel add-in specifically designed for creation advanced data analysis and visualization graphs and charts. The advanced graphs are ideal for analyzing manufacturing and engineering processes but can be equally applied to any type of data analysis such as technical writing, digital recording, mathematics teaching, software development, soil engineering and geology, and hydraulic engineering.

Advanced Graphs for Excel can produce presentation quality graphs from Excel data quickly, including many graph types not available in Excel such as polar charts, triangle plots, Mercator projections, grain size distributions and many more.

Key features of Advanced Graphs for Excel include:
  • Works with all versions of Excel from 95 and above.
  • Creates professional presentation quality advanced graphs.
  • Creates contour plots of 3 and 4-D data.
  • Can use multiple selections if data columns are not adjacent or data is arranged as expected.
  • Data is passed as floating point numbers internally is independent of the formatting.
  • Blank cells are interpreted correctly instead of assuming zero values.

The software application has many different graph types and key advanced graphs for the Excel add-in include:
  • XYXY - Select alternating X,Y columns to produce an XY plot (Column selections may have differing numbers of rows). Use a logarithmic or probability scale on either axis or to display the data as a bar chart, polar chart, or any of the other graph types supported. Customize the line style, symbol style, line width, symbol height, or color of any curve on the graph.  
  • XYYY - Same as the XYXY but X is taken from the first selected column and all subsequently selected columns are Y values for separate curves. If only one column is selected, it is assumed to be Y values and X is generated, starting at 0 and incremented by 1. Y columns may have blank cells.     
  • X, Y, Label - Creates 1 curve on an XY plot with X taken from the first selected column. Y is taken from the second selected column, and text labels in the third column. Label cells may be blank.     
  • Bar chart - Creates a bar chart with non-numeric labels on the X axis and 1 or more groups of amplitudes.
  • Bar chart, data in rows - Same as Bar chart command, with data sets in the same row rather than the same column.     
  • One Curve Per Row - Similar to XYXY, but data is arranged by rows rather than columns, with alternating X and Y values in adjacent columns. Each row is used to produce one curve.
  • XYZ Surface - Select an X, a Y, and a Z column (one or more selections) to produce a 3D surface plot.
  • XYZ Scatter - Select one or more groups of X, Y, Z columns and produce a 3D scatter plot, one data set per X, Y, Z group.     
  • Z Grid - Select a table with X in the first row, Y in the first column, and the remainder of the table filled with Z values for the corresponding X and Y to produce a 3D surface plot.   
  • Z Scatter Table - Similar to Z Grid but produces a scatter plot rather than a surface plot.
  • One D - Select one or more columns of amplitudes and produce a box-and-whisker plot.

Download Buy Now
(Pricing is available on the next page)

Related Excel Solutions:Chart Trend Analysis-Technical Analysis  3D Charts-Presentation and Reporting  Treemap Add-in-Presentation and Reporting  Advanced Charts-Technical Analysis  Curve Fitting-Manufacturing and Engineering  Compatible Alternative-Converting and Integrating  Data Plotting-Technical Analysis  Sankey Diagrams-Manufacturing and Engineering  3D Bubble Charts-Forecasting and Prediction

Share your thoughts with other users: Create your own review
 


Popular Searches




Upgrade Excel with always the latest Office apps
Get Office 365

   
  © 2014 Business Spreadsheets. All Rights Reserved. Legal | About Us