|
Keywords: Sigma Plot, Student, Discount, Price, Sigma Plot, Student, Discount, Prices, sigma plot, student, discount, prices, sigma plot, student, discount, price
Create a Sigma Plot Graph in Excel
Examples have been given showing how to copy a Sigma Plot graph to PowerPoint and Word. In these cases macros were written in Sigma Plot. The can also write a macro in Excel (or Word or PowerPoint) that
works with Sigma Plot graphs. The Excel macro discussed here will
- Open Sigma Plot
- Copy the Excel worksheet data
- Create a worksheet in Sigma Plot and paste the Excel data into it
- Create the Sigma Plot graph (in Sigma Plot)
- Copy the Sigma Plot graph and paste it on the Excel worksheet
These are the same steps as used by the Sigma Plot macros except in this case you have to open Sigma Plot and get the Excel data to it.
A simple example of a macro that creates a Sigma Plot graph in Excel may be downloaded and studied. This macro creates a scatter plot with regression line from two selected columns
of Excel data and places the graph on the Excel worksheet.
After downloading the Create Sigma Plot Graph.xls Excel worksheet, place it into the \Program Files\Microsoft Office\Office\XLStart folder. Then start Excel and enter data in two
columns of the Excel worksheet. Be sure to select the two columns to be graphed as the macro copies the selected columns.
Then run the macro from the Tools menu item
to produce the Sigma Plot graph in the Excel worksheet.
When you use a macro frequently it is helpful to create a button or command to access it. As an example, lets create a button. Choose the Excel Tools
menu Customize command, select Macros as the Category,
and then drag the custom button to a toolbar.
Click on the Modify Selection button in the Customize dialog to change the button icon if you wish and then close this dialog. You will need to assign the
button to a macro when you first click on it as shown below.
Subsequent use of the custom macro button will run the macro.
Back to Sigma Plot Product Uses Page.
|
