per la creazione di grafici e la visualizzazione dei dati
Grazie a un’interfaccia pluripremiata e a un’intuitiva tecnologia guidata che guida gli utenti passo dopo passo nel processo di creazione dei grafici e di analisi dei dati, SigmaPlot offre la flessibilità necessaria per creare grafici e analisi statistiche convincenti che non si possono ottenere con un semplice foglio di calcolo.
Adalta è Rivenditore Unico per l’Italia di Grafiti SigmaPlot. Richiesta quotazione…
A cosa serve SigmaPlot
SigmaPlot aiuta a creare rapidamente grafici accurati
Con la nuova interfaccia grafica delle proprietà è possibile selezionare la categoria di proprietà nell’albero a sinistra e quindi modificare le proprietà a destra. La modifica viene immediatamente graficata e se si sposta il cursore dal pannello, questo diventa trasparente e si può vedere l’effetto delle modifiche senza uscire dal pannello.
La procedura “seleziona a sinistra e cambia a destra” rende la modifica dei grafici facile e veloce. SigmaPlot vi porta oltre i semplici fogli di calcolo per aiutarvi a mostrare il vostro lavoro in modo chiaro e preciso. Con SigmaPlot potete produrre grafici di alta qualità senza passare ore davanti al computer. SigmaPlot offre una perfetta integrazione con Microsoft Office®, per cui è possibile accedere facilmente ai dati dei fogli di calcolo di Microsoft Excel® e presentare i risultati in presentazioni di Microsoft PowerPoint®.
L’interfaccia utente include anche controlli a nastro in stile Microsoft Office. L’interfaccia della finestra a schede organizza in modo efficiente i fogli di lavoro e i grafici per facilitarne la selezione. Le schede possono essere organizzate in gruppi di schede verticali o orizzontali. I riquadri di Graph Gallery e Notebook Manger possono essere spostati in qualsiasi posizione e posizionati facilmente grazie alle guide del pannello di aggancio. È possibile aggiungere oggetti di uso frequente alla “Quick Access Toolbar”. Ad esempio, si possono aggiungere le opzioni Salva blocco note, Chiudi tutto, Aggiorna pagina grafica e Modifica tracciato.
Più di 100 tipi di grafici tecnici 2D e 3D
Dai semplici grafici di dispersione 2D agli avvincenti grafici a contorno e ai nuovi grafici radar e a densità di punti, SigmaPlot vi offre l’esatto tipo di grafico tecnico di cui avete bisogno per le vostre ricerche più impegnative. Inoltre, per aiutarvi a vedere le interazioni tra i vostri dati in 3D, SigmaPlot è in grado di renderizzare più maglie tridimensionali intersecanti con la rimozione delle linee nascoste. Con così tanti tipi di grafici e diagrammi tra cui scegliere, potrete sempre trovare la migliore rappresentazione visiva dei vostri dati.
Utilizzate il Global Curve Fitting per analizzare simultaneamente più dati.
il Global Curve Fitting viene utilizzato quando si desidera adattare un’equazione a più serie di dati contemporaneamente. L’equazione selezionata deve avere esattamente una variabile indipendente. I set di dati possono essere selezionati da un foglio di lavoro o da un grafico, utilizzando una varietà di formati di dati. È inoltre possibile specificare il comportamento di ciascun parametro dell’equazione rispetto ai set di dati. Un parametro può essere localizzato per avere un valore separato per ogni set di dati, oppure può essere condiviso per avere lo stesso valore per tutti i set di dati.
La procedura guidata per il Global Curve Fitting è molto simile alle procedure guidate per la regressione e l’adattamento dinamico per quanto riguarda la struttura e il funzionamento. La differenza principale è il pannello aggiuntivo mostrato di seguito per specificare i parametri condivisi.
Ottenere dati da quasi tutte le fonti
SigmaPlot dispone di formati di importazione per tutti i più comuni file di testo. Tra questi, un importatore di file ASCII di uso generale che consente di importare file delimitati da virgole e delimitatori selezionati dall’utente. Inoltre, è possibile importare tutti i formati di Excel. I formati di input dei dati SPSS, Minitab, SYSTAT e SAS sono supportati da SigmaPlot.
È possibile importare file elettrofisiologici binari e di testo di Axon. Inoltre, il modulo Elettrofisiologia, acquistabile separatamente, consente di importare parti specifiche di file elettrofisiologici dai file ABF di Axon Instruments, dal formato Acquire di Bruxton Corporation e dal formato Pulse di HEKA electronik. Importazione di qualsiasi database compatibile con ODBC. Sono supportati i file di database Excel e Access. Esecuzione di query SQL sulle tabelle e importazione selettiva delle informazioni.
SigmaPlot Features
Choose from a wide range of graph types to best present your results
SigmaPlot provides more than 100 different 2-D and 3-D graph types. From simple 2-D scatter plots to compelling contour, Forest and radar plots, SigmaPlot gives you the exact technical graph type you need for your demanding research. With so many options, you can always find the best visual representation of your data.
Statistical Analysis is no longer a daunting task
SigmaPlot now offers almost 50 of the most frequently used statistical tests in scientific research by integrating SigmaStat into one application. Suggestion of the most appropriate statistical tests is offered by a software-based Advisor. Raw and indexed data formats are accepted to avoid data reformatting.
Violation of data assumptions is checked in the background and, if true, the correct test to use is recommended. Reports with descriptive interpretations are generated and graphs specific to each test may be created.
SigmaPlot now employs an all new user interface allowing users to easily setup a global curve fit. This gives users the ability to easily share one or more equation parameters across multiple data sets.
Non-linear curve fitting is known to produce incorrect results in some instances.The problem is that you don´t necessarily know that this has happened. Dynamic Curve Fitting is designed to determine if this has happened and if so what the likely best fit is.
Export your graphs as high-resolution, dynamic Web pages – not simple GIF or JPEG files. Viewers can explore data used to create graphs and zoom, pan or print images at full resolution directly from a Web Browser. Automatically generate active Web objects from your graphs or embed the objects within other Web pages.
- Simply select the Web graph to share its data with colleagues and students
- Share the data behind your graphs with colleagues and students
- Enable colleagues to print your full report from your intranet or Web site directly from their browsers – without compromising the quality of the graphs
- Create an optional password while exporting your graph to limit data access to authorized users
- Produce Web documents without knowing HTML or embed SigmaPlot Web object graphs within HTML files to create interactive electronic reports
Each worksheet can hold a list of user defined transforms that will automatically be re-run whenever the transform input data has changed.
Let’s say you would like to start by selecting a particular kind of graph but you don’t know how to set up the worksheet to achieve it. SigmaPlot lets the user select a graph first and then gives you a pre-formatted worksheet to structure their data. The data entered into the worksheet is immediately displayed on the graph. This feature can demonstrate to you the strong relationship between the data format and the graph type.
Import
- Excel, ASCII Plain Text, Comma Delimited, MS Access
- General ASCII import filter
- SigmaPlot DOS 4.0, 4.1, 5.0 data worksheets, SigmaPlot 1.0, 2.0 Worksheet, and 3.0, 4.0, 5.0, 6.0, 7.0, 8.0, 9.0, 10.0 and 11.0 Windows, SigmaPlot 4.1 and 5.0 Macintosh data worksheets
- Comma delimited and general purpose ASCII import filter
- Symphony, Quattro Pro, dBASE E, DIF, Lotus 1-2-3, Paradox
- SigmaStat DOS and 1.0 worksheets, SYSTAT, SPSS, SAS data set V6. V8, V9, SAS export file, Minitab V8 to V12
- SigmaScan, SigmaScan Pro, SigmaScan Image, Mocha
- TableCurve 2D and 3D
- Axon Binary, Axon Text
- Import ODBC compliant databases
- Run SQL queries on tables and selectively import information
- Import Excel 2007 files directly into SigmaPlot
Export
- Excel, ASCII Plain Text, Tab delimited, Comma delimited
- SigmaPlot 1.0, 2.0, and 3.0 for Windows, SigmaPlot 5.0 for Macintosh data worksheets
- SigmaPlot 7.101, 8.0, 9.0, 10.0, 11.0
- SigmaScan, SigmaScan Pro, SigmaScan Image, Mocha
- SigmaStat 2.0, SYSTAT, SAS V6 data set, Minitab V11
- Vector PDF and HTML export of graphs and reports
- Symphony, Quattro Pro, dBASE III, DIF, Lotus 1-2-3, Paradox
- Graph formats: JPEG, GIF, PNG, HTML, TIFF CMYK, TIFF RGB, Bitmap, Metafile (wmf), Enhanced Metafile (emf), PDF, PSD, EPS, PDF vector, SVG, SWF
Graphing software that makes data visualization easy
Graph creation starts with SigmaPlot’s award-winning interface. Take advantage of ribbon collections of common properties, tabbed selection of graphs, worksheets and reports, right mouse button support and graph preferences. Select the graph type you want to create from the Graph Toolbar’s easy-to-read icons. The interactive Graph Wizard leads you through every step of graph creation. You get compelling, publication-quality charts and graphs in no time. SigmaPlot offers more options for charting, modeling and graphing your technical data than any other graphics software package.
Compare and contrast trends in your data by creating multiple axes per graph, multiple graphs per page and multiple pages per worksheet. Accurately arrange multiple graphs on a page using built-in templates or your own page layouts with SigmaPlot’s WYSIWYG page layout and zoom features.
Customize every detail of your charts and graphs
SigmaPlot offers the flexibility to customize every detail of your graph. You can add axis breaks, standard or asymmetric error bars and symbols; change colors, fonts, line thickness and more. Double-click on any graph element to launch the Graph Properties dialog box. Modify your graph, chart or diagram further by pasting an equation, symbol, map, picture, illustration or other image into your presentation. And select anti-aliasing to display jaggy-free smooth lines that can be used in your PowerPoint® presentations.
Quickly Plot your Data from Existing Graph Templates in the Graph Style Gallery
Save all of the attributes of your favorite graph style in the Graph Style Gallery. Add greater speed and efficiency to your analysis by quickly recalling an existing graph type you need and applying its style to your current dataset.
- Quickly save any graph with all graph properties as a style and add a bitmap image to the gallery
- No need to be an expert, create customized graphs in no time with the Graph Gallery
- Choose an image from the Graph Style Gallery to quickly plot your data using an existing graph template
- Save time by using a predetermined style to create a graph of the data
- Avoid re-creating complex graphs
But, remember, you don’t necessarily need to use the power of the Graph Gallery since every graph in SigmaPlot is a template. In the Notebook Manager, you can copy and paste a graph from one worksheet to another and all the attributes of that graph are applied to the new data saving much time.
Publish your charts and graphs anywhere
Create stunning slides, display your graphs in reports or further customize your graphs in drawing packages. Save graphs for publication in a technical journal, article or paper with SigmaPlot’s wide range of graphic export options. Presenting and publishing your results has never been easier – or looked this good.
Create customized reports with SigmaPlot’s Report Editor or embed your graphs in any OLE (Object Linking and Embedding) container – word processors, Microsoft PowerPoint or another graphics program. Then, just double click your graph to edit directly inside your document. Quickly send your high-resolution graphs online to share with others.
Export your graphs ashigh-resolution, dynamic Web pages – not simple GIF or JPEG files. Viewers can explore data used to create vector graphs and zoom, pan or print images at any resolution directly from a Web Browser. Automatically generate active Web objects from your graphs or embed the objects within other Web pages.
- Share the data behind your web-based graphs with colleagues and students
- Enable colleagues to print your full report from your intranetor Web site directly from their browsers – without compromising the quality of the graphs
- Create an optional password while exporting your graph to limit data access to authorized users
- Produce Web documents without knowing HTML, or embed SigmaPlot Web object graphs in existing HTML files to create interactive electronic reports
Data Analysis Doesn’t Get Much Easier
SigmaPlot provides all the fundamental tools you need to analyze your data from basic statistics to advanced mathematical calculations. Click the View Column Statistics button to instantly generate summary statistics including 95% and 99% confidence intervals. Run t-tests, linear regressions, non-linear regressions and ANOVA with ease. You can fit a curve or plot a function and get a report of the results in seconds. Use built-in transforms to massage your data and create a unique chart, diagram or figure. With SigmaPlot – it’s all so simple!
Use SigmaPlot within Microsoft Excel
Access SigmaPlot right from your active Microsoft Excel worksheet. Tedious cut-and-paste data preparation steps are eliminated when you launch SigmaPlot’s Graph Wizard right from the Excel toolbar. Use Excel in-cell formulas, pivot tables, macros and date or time formats without worry. Keep your data and graphs in one convenient file.
Transforms and Quick Transforms
Generate simulated data or modify worksheet columns of data with transforms. Create simple one-line transforms with the Quick Transforms feature that walks you through transform implementation. Or create extremely complex transforms with hundreds of lines of code.
Use the Regression Wizard to fit data easily and accurately
Fitting your data is easy with the SigmaPlot Regression Wizard. The Regression Wizard automatically determines your initial parameters, writes a statistical report, saves your equation to your SigmaPlot Notebook, and adds your results to existing graphs or creates a new one!
The Regression Wizard accurately fits nearly any equation – piecewise continuous, multifunctional, weighted, Boolean functions and more – up to 10 variables and 25 parameters. You can even add your own curve fit equations and add them to the Regression Wizard.
Use the Dynamic Curve Fitter to determine if your fit is valid
The Dynamic Curve Fitter performs 200 or more curve fits using your equation and data starting from optimally different initial starting values. The results are ranked by goodness of fit so that you can check the top ranked results against the result you obtained from the Regression Wizard.
For many simple equations, which are fit to data sets with a sufficiently large number of data points, the Dynamic Curve Fitter finds the same result as the Regression Wizard. But the problem is that the user simply does not know whether the solution found by the Regression Wizard is the best possible or not. So there is always a concern that the correct solution has not been found. Dynamic fitting minimizes this concern. Its use is encouraged prior to publishing results particularly if a complicated equation is used.
Plot Nearly ANY Mathematical Function
Plotting user-defined and parameterized equations is only a mouseclick away with the Plot Equation feature. Just type the function or select one from the built-in library and specify the parameters and the range. It’s that simple! Create your own built-in functions and save them for future use. Plot functions on new or existing graphs or plot multiple functions simultaneously using different parameter values. Save plotted X and Y results to the worksheet.
Maximize your Productivity with SigmaPlot’s Automation
Automate Complex Repetitive Tasks
Create macros in no time with SigmaPlot’s easy-to-use macro language. Not a programmer? No problem. With SigmaPlot, you can record macros by point-and-click with the macro recorder. Use macros to acquire your data, execute powerful analytical methods, and create industry-specific or field-specific graphs. Use one of the thirty built-in macros as provided or use these macros as a base to quickly create your own macros.
Share the power of SigmaPlot with less-experienced users by using macros to tailor the SigmaPlot interface for your particular application. Create custom dialog boxes, menu choices and forms to help guide novice users through a session.
Tap into SigmaPlot’s Powerful Capabilities from Within Other Applications
Call on SigmaPlot´s functionality from external sources that have Visual Basic embedded including Microsoft Word®, Microsoft Excel®, Microsoft PowerPoint® or custom software applications. Analyze and graph your data using SigmaPlot within those applications.
For example, you can run a Visual Basic script in Microsoft Word® or Excel® that calls on SigmaPlot to generate and embed your graph in the document. SigmaPlot´s OLE2 automation provides unlimited flexibility.
SigmaPlot Has Complete Advisory Statistical Analysis Features
SigmaPlot is now a complete graphing AND an advisory statistics suite. All of the advanced statistical analysis features found in the package known as SigmaStat have now been incorporated into SigmaPlot along with several new statistical features. SigmaPlot guides users through every step of the analysis and performs powerful statistical analysis without the user being a statistical expert.
In addition to the EC50 value already computed, the user can also compute other user-entered EC values such as EC40 and EC60 and compute them instantly. Two five-parameter logistic functions have also been added and the Dynamic Curve Fitting feature included to help solve difficult curve fitting problems.
In earlier versions of SigmaPlot, almost all objects in a 2D graph were selectable with just a mouse click. However, almost all objects in a 3D graph were not. SigmaPlot now adds mouse selectability of all 3D graph objects with the ability to customize all 3D objects.
New Worksheet Features Include
- Import Excel worksheet data into a SigmaPlot worksheet or Open an Excel worksheet as an Excel worksheet in SigmaPlot
- Mini toolbar for worksheet cell editing
- Zoom enabled worksheet
- Worksheet scrolling with mouse wheel
- Line widths may be placed in the worksheet for graph customization
- Formatted text (subscript, etc.) in worksheet cells
Create stunning slides, display your graphs in reports or further customize your graphs in drawing packages. Save graphs for publication in a technical journal, article or paper with SigmaPlot’s wide range of graphic export options. Presenting and publishing your results has never been easier – or looked this good. Create customized reports with SigmaPlot’s Report Editor or embed your graphs in any OLE container – word processors, Microsoft PowerPoint or graphics program. Just double click your graph to edit directly inside your document. Quickly send your high-resolution graphs online to share with others.
SigmaPlot’s Notebook Functionality
- Can hold SigmaPlot worksheets, Excel worksheets, reports, documents, regression wizard equations, graph pages, and macros.
- New dialog-bar-based notebook that has several states: docks, re-sizable, hide-able, summary information mode, etc.
- Browser-like notebook functionality that supports drag-n-drop capabilities
- Direct-editing of notebook summary information
Automate Routine and Complex Tasks
- Visual Basic compatible programming using built-in macro language interface
- Macro recorder to save and play-back operations
- Full automation object support – use Visual Basic to create your own SigmaPlot-based applications
- Run built-in macros or create and add your own scripts
- Add menu commands and create dialog boxes
- Toolbox ribbon: helpful macros appear as separate grouped items
- Export graph to PowerPoint Slide (macro)
- “Insert Graph to Microsoft Word” Toolbox ribbon macro
- Keyboard shortcuts in the Graph page and most Microsoft Excel keyboard shortcuts in the worksheet.
Symbol Types
- Over 100 symbol types
- 30 new symbol types that include half-filled and BMW styles
- Edit font when using text as symbol
- Access new symbols directly from graph properties dialog, toolbar, legend page and the symbol dialog box
- More line types such as dash and gap patterns
- More fill patterns for bar charts and area plots, that can be independently set from the line color
SigmaPlot Report Editor
- Cut and paste or use OLE to combine all the important aspects of your analysis into one document.
- Copy / Paste tabular data between report and Excel worksheet
- Choose from a wide range of styles, sizes and colors from any system font
- New tables with pre-defined styles or user customized
- Export to most word processors
- Add decimal tabs, tab leader, true date/time fields
- Vertical and horizontal rulers for report formatting
- Auto-numbering
- Change report background color
- Improved formatting ruler
- Zoom enabled in reports
- Drag and drop Word 2007 and 2010 documents into reports
Page Layout and Annotation Options
- OLE 2 container and server
- Automatic or manual legends
- True WYSIWYG
- Multi line text editor
- Multiple curves and plots on one graph
- Multiple axes on one graph
- Arrange graphs with built-in templates
- Multiple levels of zooming and custom zooming
- Scale graph to any size
- Resize graphic elements proportionally with resizing graph
- Alignment and position tools
- Draw lines, ellipses, boxes, arrows
- Layering options
- Over 16 million custom colors
- Inset graphs inside one another
- Selection of graph objects
- Right-click property editing
- New zoom, drag and pan controls
- Mouse wheel scrolling enabled
- Right-click property editing for 3D Graphs
- Color schemes
- Paste graphic objects from other
Novità e miglioramenti in SigmaPlot 15.1
Sigmaplot v15.1 Patch 1 Release Notes
- Fixed Wrong License Manager error
- The about screen was updated to include the proper dates and tools
- Added new functionality to For Loops in the transform language. The old behavior was non standard, but the user can change back to it with an ini file change.
- Help topic and button was added for the Heat Map macro.
- Modified the Help entry for the Ribbon Configuration menus as we moved them to the Quick Access Toolbar
- Added the Statistics Graphs to the Create Graph ribbon tab and added Help for this.
- Add help for the new feature for SPW 15 of being able to save result graph data with reports.
- Improved the User’s Guide (pdf)
- Modified the SigmaPlot Macro Sample File which added a button for the Parametric and Polar Plot Equation macro into the Macro tab on the ribbon.
- Added several improvements for graph export:
- Added dithering to 256 Color and grayscale images to make the color transition across the bitmap smoother.
- Added CMYK TIFF files for 24-bit color.
- Improved the basis for the available memory warning when exporting bitmaps to depend on actual memory currently used be application.
- Significantly Improved the speed of updating the preview control when changing color depth.
- Added a proper icon for the Column Means statistics graph
- Improved the splash screen to use the proper year
- Fixed a crash opening older files
- Fixed a crash with saving report graph data with the notebook
Novità e miglioramenti in SigmaPlot 15
SigmaPlot Version 15 has new features to make your work easier.
New Graph Type (Via a Macro)
Heat Map
Clustered Heat Maps Macro
Description of Heat Maps
A clustered heat map is a visualization of numeric data assigned to the levels of two categorical variables. This type of data can be displayed in a table where the rows refer to the levels of one variable and the columns refer to the levels of the other variable. The data table is typed into a SigmaPlot worksheet.
A heat map for this two-way data is constructed as a rectangular array of solid colors. The dimensions of the array and the positions of its individual color cells match the arrangement of the heat map data in the worksheet. The methods of assigning colors to data values are discussed below.
Heat maps assist in visualizing variations in the density of values in the data table. Put another way, heat maps are used to identify clusters of data.
Applications
The primary benefit of heat maps is that they make complicated data simpler to understand than the output of many other graphical or numerical techniques. One of the original applications of heat maps that is frequently used is to examine population density in a city or region. Heat maps are used by professionals in a variety of different fields:
- Business analytics – exploring data for a range of improvements and degrees of performance.
- Websites – visualizing the behavior of visitors.
- Exploratory Data Analysis – obtaining a relatively quick examination of data before deciding on how to model the data for more in-depth analysis.
- Molecular Biology – study patterns of difference and similarity in DNA and RNA.
- Marketing and Sales – showing how marketing and sales can be targeted by assessing sale trends and customer response in various geographic or demographic areas.
Input Data
Worksheet data for a heat map is arranged in a number of columns. One column is for column labels and another column is for row labels. These labels appear on the axes for the heat map. You are allowed to create a heat map without providing labels.
The data to be selected for the heat map must be entered in adjoining columns. The number of rows of data can vary among the columns. When the heat map is created, the number of rows in the heat map equals the maximum number of rows in the selected data. Non-numeric data is allowed in the data table, but will be treated as missing values. The color assigned to a missing value is transparent.
One more column is needed for a color palette that will be used to generate the heat map colors. The palette is created by the user by using the Insert Graphic Cells dialog, the transform language, or manually by typing in a color code.
The colors assigned to the worksheet data depend on whether a discrete or continuous color scale is selected. The scales are based on the palette in the color column. For discrete color scales, the color column often uses an existing color scheme of 7 to 10 colors. For continuous color scales, the color column often contains only two or three colors, but can contain more.
Examples of heat map data are accessed from the Macro Data button in the Samples Files group on the Help tab of the SigmaPlot ribbon. When the button is pressed, the Macro Data Sets notebook opens in the Notebook Manager and heat map examples are provided in three sections.
An example of input data for heat maps is shown below.
Options
The Create Heat Map macro is accessed by pressing the Heat Map button in the Graphing Tools group on the Tools tab of the SigmaPlot ribbon. When running the macro, a dialog box appears for setting options to create a heat map. The settings are:
- Select the worksheet column in the Column labels drop-down list for the heat map’s column labels. Leave the display value blank if no column labels will be used.
- Select the worksheet column in the Row labels drop-down list for the heat map’s row labels. Leave the display value blank if no row labels will be used.
- Select the worksheet column in the First data column drop-down list for the first or leftmost column of the heat map’s data table. This selection is required.
- Select the worksheet column in the Last data column drop-down list for the first or leftmost column of the heat map’s data table. This selection is required.
- Select the type of color scale used in the heat map, either Discrete color scale or Continuous color scale.
If using a discrete color scale, the first color of the color column is assigned to the minimum of the data and the last color of the color column is assigned to the maximum of the data. The range of the data is then divided up uniformly into groups and the data within each group is assigned to the corresponding color in the palette.
If using a continuous color scale, the first color of the color column or default color palette is assigned to the minimum of the data and the last color of the color column or default color palette is assigned to the maximum of the data. Linear interpolation on the components of the palette colors is used to assign a color to a particular data value based on the proportion of the data range for locating that data value.
- Color bars show the data to color conversion scale. Select the Show Color Bars to indicate whether color bars are or are not displayed, and if displayed, decide whether the color bar orientation is vertical (the default) or horizontal.
- When the Display numeric values in heat map checkbox is checked, a symbol plot showing the heat map data table is created and placed on top of the heat map so that numeric values, including missing values, are displayed over the corresponding heat map cells.
- The Select colors group box has two options for selecting the color palette. A Color column drop-down list is provided to select the palette from the worksheet. The alternative is to select the Use default colors shown below If this checkbox is checked, the heat map colors are created using a continuous color scale.
The Create Heat Map macro dialog box is shown below with settings made for the worksheet data shown above.
The settings in the dialog are saved to a text file in the user’s profile folder after pressing the OK button. When relaunching the macro, the dialog controls will show the same settings as before.
Output
After pressing the OK button, the macro code computes the graph data for the heat map, color bar, and data table plot, depending on the selected settings. After the graph data is placed in the worksheet, the graphing code in the macro creates a graph page showing the selected plots.
The heat map graph data consists of a rectangular array of all 1s that has the same dimensions as the heat map’s data table. The heat map is actually created as a horizontal stacked bar chart and this array is used to set the number and relative size of the bars for the heat map. In addition, there is a column of color data for the heat map where the number of colors in the column equals the number of cells in the data table. This gives a total of N + 1 columns for the graph data of a heat map where N is number of columns in the input data table.
The data table symbol plot contains three columns of graph data. The first two columns give the coordinate positions of the data values in the heat map. The last column is a list of all data values in the data table, column by column, but converted to text as is needed for a symbol plot.
The color bar also contains three columns of graph data. A vertical (horizontal) color bar is created as a horizontal (vertical) bar chart. If using a continuous color scale, the first column consists of 101 numeric values that uniformly span the range of the heat map data. The second column consists of 101 values, all equal to 1, for setting the size of the bars. The last column applies the color scale to the first column of data values to generate 101 colors for the color bar. If using a discrete color scale, then the same types of columns are created, but each column has the same number of rows as the color column selected in the dialog.
For the above worksheet data and setting shown above in the dialog, the heat map appears as below. After the graph is created, the Graph Properties dialog can be used for any desired edits.
UI Modifications for Improved User Experience
New and refreshed Ribbon Manager
- The new and refreshed ribbon manager enhances the already commendable user experience in SigmaPlot.
- Ribbons provide context sensitive feature groupings for enhanced functionality and ease of use.
- Icons are now desaturated, have high resolution and have expanded tooltips containing hot keys.
- Keyboard shortcuts are provided by the Alt Key-Tips.
This refreshed ribbons manager enhances the user experience providing the user with easy navigation across the various functions of SigmaPlot v15.
New Home Button
- The eye catching SigmaPlot Home button provides the user with easy navigation to Quick Start, Create New Notebooks, Open any saved SigmaPlot file, export to previous versions of SigmaPlot (up to SigmaPlot 11) and workbook protection with password and audit trails.
- SigmaPlot’s easy-to-use macro language helps users create macros in no time. Not a programmer? No problem. With SigmaPlot, you can record macros by point-and-click with the macro recorder. Use macros to acquire your data, execute powerful analytical methods, and create industry-specific or field-specific graphs.
- Use one of the thirty built-in macros as provided or use these macros as a base to quickly create your own macros.
- The refreshed SigmaPlot v15, has a separate tab for Macros, making it easier for users to navigate to this great functionality of SigmaPlot.
- There are over 30 macros in SigmaPlot, giving users the capability of programmatic control over SigmaPlot features.
- Help topics are immediately visible and separated into groups of similar types.
- Faster access to topics than the prior Help menu where topics were displayed using drop-down lists.
- Improved search in Help, giving you instant access to various Help Topics like Tutorials, User Guides, Technical Support and information on your current licensed version of SigmaPlot.
Ribbons Configuration functionality available via a Quick Access Tab
- The Ribbons configuration is now available on a Quick Access Tab from where instantly you can change the configurations between Default, Compact, Graphing & Analysis
Histograms group on Analysis Tab
- The analysis tab is the primary interface for data analysis features in SigmaPlot.
- The tab has been rearranged for easier use and includes a new Histograms group for better access to creating graphs with more advanced properties.
- Provides access to macros and apps that interface with SigmaPlot features to extend the program’s capabilities.
- The Graphing Tools group provide macros (tools) to create special graph types.
- The Office Tools group provides macros to send SigmaPlot results to Microsoft Office products.
- The Pharmacology group provides useful tools for Pharmacology studies.
- The Dot Density Overlay Plots macro is now exposed on the new Tools tab for greater accessibility
Analysis Features
Result Graphs
- Save result graph data with statistical reports.
- View and Save statistics results’ graph data with the option to revert to not saving result graph data with reports in case storage size becomes a problem. (Save result graph data with reports for anytime graph creation, turned on by default).
- A new check box allows the dialog to keep running after the Run button is pressed. Helpful for testing the results of a transform after making a series of changes to the transform text.
Miscellaneous Items
Changed clipboard format for Excel to CF_SYLK
- so numbers pasted from Excel have full precision with the option to change Excel pasting in SigmaPlot to use the clipboard format CF_UNICODETEXT. (Paste numeric data from Excel into SigmaPlot using full precision without ability to paste non-ASCII characters.)
- New Cloud based License Manager Server with 24/7 availability
- SigmaPlot v15 has the latest Sentinel License Manager which is compatible with the latest Microsoft Server 2022
Removed older Microsoft VS 2005 Redistributable
The new SigmaPlot v15 Removes all dependencies on old Visual Studio 2005 redistributable by replacing older software for graph export
Requisiti di sistema di SigmaPlot
Hardware
- 2 GHz 32-bit (x86) or 64-bit (x64) Processor
- 2 GB of System Memory for 32-bit (x86)
- 4 GB of System Memory for 64-bit (x64)
- 300 MB of Available Hard Disk Space
- CD-ROM Drive or Internet Connection
- 800×600 SVGA/256 Color Display or better
- Internet Explorer Version 8 or better
Software
- Windows XP, Windows Vista, Windows 7, Windows 8.x, Windows 10; Internet Explorer 6 or higher
- Office 2003 or higher (paste to Powerpoint Slide, Insert Graphs into Word and other macros)