Hi. Scrub my previous post. I have read another post where you answer this question.

chris

]]>Graph allows for the x-axis to have a radians scale by checking the "show as multiples of pi" checkbox. This is useful for seeing trig functions in radians. Can you setup a similar feature where we can see trig functions with the x-axis in degrees (for exanple seeing the first period of any trig function going from -180 degrees to 180 degrees or 0 degrees to 360 degrees).

I could do this using the zoom button but this would not illustrate the first period of a trig functions.

chris

]]>Thanks. I created an Excel fle containing 30 columns of data, each column containing 500 values, and Graph managed to import this file as 29 separate point series without any problems.

chris

]]>https://www.padowan.dk/bin/plugins/ImportExcel.zip]]>

Yes, you're right about querying where x=i would be on the Re axis. I wasn't thinking straight at the time I tried this example out. This is an example of the user (me) not paying attention. In this sense it would be good for an error messsage to come up such as "invalid input".

chris

]]>Thanks. I love the way you can plot the 1st Excel column versus the 2nd and subsequent Excel columns as different point series.

The problem (if it is a problem) is that in the point-series dialogue box some values are not listed exactly as they are listed in the Excel file. For example, starting with a value of "0.6" in cell A1, I then generate subsequent values of 0.7 to 1.5 using the formula "=A1+0.1" and copying this formula all the way down to cell A10. But Graph doesn't import these values exactly as they are. E.g. 0.8 in Excel become 0.7999999999999999 in graph (Pic attached)

Can you fix this?

chris

]]>You are probably right that Graph should at least give a warning in this case. I will try to implement that. I don't know where you expected x=i to be on the x-axis. However I actually thought y=i^2 would work. But I can see that Graph evaluates points using real numbers only. I will fix that so they can evaluate using complex numbers as long as the result is a real number.]]>

However your file doesn't have anything in column A, which is why the imported point series contain no values. To make it work you need to place all the x-values in column A and the y-values in column B, C, D, etc. You also need to start the values from row 1, though it will also work if you have a description in row 1 and start the values in row 2.

I can see that the plugin doesn't work when the Excel file contains formulas. I have now fixed that in an updated plugin:

https://www.padowan.dk/bin/plugins/ImportExcel.zip

chris

]]>Hi. I have using point series to plot a complex number such as 3 + 2i where I type 3 as the x value and 2 as the y values. I then decided to plot i + i^2 by typing in "i" as the x value and "i*i" as the y value (I have set "calculate with complex numbers"). The series name is displayed in the legend but nothing is drawn and no error message is produced. I think it might be useful to either allow this type of input to work, or to have an error message produce if you only want users to type in real numbers. Attached is an image of how I have done this.

chris

]]>Hi. Here is the excel file I used.

chris

]]>Sorry for the late reply. Thanks for the effort. I have downloaded Graph 4.5 Beta to test this out and it doesn't seem to work. I created a one-sheet Excel file containing two columns of numbers (with no headings or anything, just columns of numbers). I was thinking that Graph would read the left column (which runs from 0.6 to 1.5 in steps of 0.1) as the x-axis, and the right column (which is just zeros) as the y axis data.

I then went to Graph -> File -> Import -> Excel file and the result I got is shown in the attached jpg. None of my points were plotted and Graph created 4 separate points series, each of these empty.

chris

]]>https://www.padowan.dk/bin/plugins/ImportExcel.zip

You need the beta version of Graph 4.5 from https://padowan.dk/beta

You can install the plugin from the Plugin Manager in the *Plugins* menu. When installed you will have a menu item *Files|Import|Excel file* in the main menu and an *Import Excel file* menu item in the context menu in the *Insert pointseries* dialog.