The image above shows a scatter chart that displays two different complex numbers and their sum, in total three different complex values.
Complex numbers in rectangular form a+bi have real and imaginary values which are positive, negative or zero, this makes it possible to use a chart with two dimensions x and y.
The imaginary values on the vertical axis (y) and the real values on the horizontal axis (x).
C1 = -1+6i (light blue)
C2 = 2-4i (green)
C1+ C2Â = 1+2i (dark blue)
Adding complex numbers means that you can put the second complex number at the first complex number, in other words, the green line starts where the light blue line ends. The dark blue complex number is the sum of C1 and C2 .
5.1 Extract real and imaginary numbers from complex numbers
The table demonstrated in the image above shows how the data needs to be arranged in order to plot different complex numbers on a chart.
Each complex number has a starting point and an ending point.
A blank row below each complex number.
Formulas for calculating real and imaginary parts.
Formula in cell C31:
=IMSUM(C25,C28)
Formula in cell D25:
=IMREAL(C25)
Formula in cell E25:
=IMAGINARY(C25)
Complex number C2 begins where C1 ends and ends where the sum is located on the complex plane.
5.2 Insert scatter chart
Select cell range D24:E31.
Go to tab "Insert" on the ribbon.
Press with mouse on the icon named "Insert Scatter (x,y)", a popup menu appears.
Press with left mouse button on the icon "Scatter with Straight Lines and Markers".
The chart shows up on the worksheet.
Press and hold with left mouse button on the chart border, then drag it to the location you want. Use the "handles" to resize the chart, see the image above.
5.3 Create arrows and change colors
Double-press with left mouse button on with left mouse button on one of the lines on the chart, all lines will be selected and a settings pane shows up.
Press with left mouse button on the "Fill&Line" button.
Press with mouse on "End Arrow type", select an arrow.
Press with mouse on "End Arrow size, pick a size.
Press with left mouse button on twice on a line to select a specific line.
Press with left mouse button on the color button on the settings pane. A popup menu appears.
Pick a color.
Repeat steps 1 to 3 with remaining lines.
There are still three markers on the chart, here is how to remove them.
Select all the lines by press with left mouse button oning on them once.
Go to the settings pane.
Press with left mouse button on "Marker Options".
Select "None".
5.4 Change axis min and max value
Double-press with left mouse button on one of the y-axis to open the settings pane.
Press with left mouse button on the "Axis Options" button.
Change the Bounds and the Units.
Repeat step 1 to 3 with the x-axis.
5.5 Change axis markers and line width
Select the y-axis.
Press with left mouse button on the "Fill & Line" button.
Press with left mouse button on the "Line".
Press with left mouse button on the "Color" button. Press with mouse on black.
Change the width to 1.5
Press with right mouse button on on one of the lines, a popup menu appears.
Press with mouse on "Add Data Labels".
Double-press with left mouse button on one of the data labels, the settings pane shows up.
Functions for backward compatibility with earlier Excel versions. Compatibility functions are replaced with newer functions with improved accuracy. Use the new functions if compatibility isn't required.
These functions let you sort, lookup, get external data like stock quotes, filter values based a condition or criteria, and get the relative position of a given value in a specific cell range. They also let you calculate row, column, and other properties of cell references.
Functions that let you manipulate text values, substitute strings, find string in value, extract a substring in a string, convert characters to ANSI code among other functions.
More than 300 Excel functions with detailed information including syntax, arguments, return values, and examples for most of the functions used in Excel formulas.
Excel Tables simplifies your work with data, adding or removing data, filtering, totals, sorting, enhance readability using cell formatting, cell references, formulas, and more.
Allows you to filter data based on selected value , a given text, or other criteria. It also lets you filter existing data or move filtered values to a new location.
Lets the user work more efficiently by showing a list that the user can select a value from. This lets you control what is shown in the list and is faster than typing into a cell.
Lets you name one or more cells, this makes it easier to find cells using the Name box, read and understand formulas containing names instead of cell references.
The Excel Solver is a free add-in that uses objective cells, constraints based on formulas on a worksheet to perform what-if analysis and other decision problems like permutations and combinations.
Format cells or cell values based a condition or criteria, there a multiple built-in Conditional Formatting tools you can use or use a custom-made conditional formatting formula.
Lets you quickly summarize vast amounts of data in a very user-friendly way. This powerful Excel feature lets you then analyze, organize and categorize important data efficiently.
VBA stands for Visual Basic for Applications and is a computer programming language developed by Microsoft, it allows you to automate time-consuming tasks and create custom functions.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form