Would you like to create Excel charts similar to these presented here? Let me know - I could help...
30 August, 2023
30 July, 2023
Charts Based On Parametric Equations: Sinusoidal (Oscilloscope-type) Curves
Curves that can be used in physics for analysing pairs of simple harmonic motions are generally known as Lissajous Curves. They describe the superposition of two oscillations taking place at the right angle to each other, at different frequencies. Their main application can be found in oscilloscopes. These instruments allow observation of two superimposed sine waves coming from varying signal voltages of sinusoidal nature. Depending on the frequency and amplitude of each wave, and the phase between them, we can see interesting patterns emerging.
Because the superimposed two perpendicular oscillations can be described with parametric equations for x and y in the Cartesian coordinate system, we can quite easily demonstrate the resulting shapes graphically using Excel charts. Let's look first at some of "oscilloscopic" patterns generated with Excel.
28 July, 2023
Shapes Based On Parametric Equations: Epitrochoids
Epitrochoids are curves generated by a point selected on a circle of smaller radius rolling around the outside
of a fixed circle of larger radius, and that selected point can be
chosen at some distance from the center of the smaller circle. These are
then 3-parametric curves. They can be helpful in creating decorative designs and other art applications, and can serve also as pastime and recreation for children. Since 1965 there is available a toy (geometric drawing device) known as spirograph, combining mathematics and art. It allows producing physically numerous curve designs based exactly on epitrochoid and hypotrochoid parametric equations.
However, nowadays the epitrochoids (as well as hypotrochoids - see another post at https://draft.blogger.com/blog/post/edit/3323809043368251287/9189797010242374274?hl=en-GB) can be generated quite easily in Excel by using VBA
macro like the one provided at the end of this post.
Here are some examples of charts showing epitrochoid curves generated with the macro. Some of them present combined double curves.
13 July, 2023
Prime Numbers: Presentation of Distribution of Primes with Waterfall Charts
One way of effective visual presentation of prime numbers is using Excel charts. And the Waterfall type of chart seems to be quite useful. It shows a running total as values are added to your data set; in this case - as consecutive primes are added. The running totals can be shown on the vertical axis as well as on the chart itself (for each subsequent prime value).
Here are some examples of this kind of visualization of running totals of primes. You'll need to enlarge the charts or use great size screen area in order to see the charts in detail.
15 May, 2023
27 August, 2021
STOCK PORTFOLIOS Tracking with Yahoo Finance in Excel - Part 3
After completing Excel tables (in Part 2) for tracking trades in your account, it's time for creating some summary of your Portfolio performance. For this purpose you can create another Excel Table (e.g. called "Portfolio Status") and a chart based on the table content. This will allow you to conduct a quick and easy visual evaluation of your investment positions.
Start with adding a new worksheet named e.g. "Performance". First, create the table. Here is an exemplary format and content:
As in previous tables the cells filled with green colour indicate data entry cells. The remaining cells contain formulas filled automatically after entering all necessary data. Cells in column E are conditionally formatted, so that cells showing gains are filled with yellow background.
05 August, 2021
How to highlight space between two plotted curves / lines
If you want to enhance your Excel charts, to fill with color some target range of the data, this procedure may be helpful.
I'm providing here two examples of such enhanced charts. In addition, I've included procedure for calculation of the surface area bounded by the two curves/lines.
Chart #1
15 June, 2021
02 May, 2021
Creating graphs based on data table; the easy way
Whatever your Excel data source (entered or generated using a formula), convert the range of cells, they occupy, into Excel table. Simply select the range and use CTRL+T shortcut to do that. This way - when you later expand your data entries (add new data) or contract the table (remove some data) - your chart will get updated automatically (dynamically).
Here is kind of a template I've used to organize my data for charting:
I could fill the table with any function data, like in this example, or with raw data and get a graph based on just one function or two, or even three or four. Sometimes, when I've plotted e.g. two functions that have had different orders of magnitude, I used a secondary axis for one of them to display results in relevant scales.
To create your graph, select X column and appropriate Y column(s), then go to Insert tab and in Charts group select whatever chart type you need. That's it.
Now format your chart as you want to. Excel provides for that the whole plethora of options. Here I'm providing just two formatting examples to show you variety of possible solutions:
Enjoy Excel Charting!