Cycle Plots - can they be created with linear data?


New Member
Mar 19, 2017
Hi everyone.

I'm new here and this is my first post ever!

I'd like to create cycle plots within Excel but although I'm fairly ok at creating formulas, I don't know VBA, Power Pivots of Power Query - yet! In fact I'm not even sure where to start! I'm aware there are instructions if you Google cycle plots BUT...

...unfortunately the instructions generally means reshaping the data in strange ways that have to be done every time data is appended or updated. This seems incredibly labour intensive and I wish to look at lots of different stock market data downloaded from yahoo.

Basically I'd like to find out if:

1. It's possible to download csv stock market data files from yahoo and be able to create a cycle plot with linear columns of data. I'm assuming it's possible to create code that will slice and dice the data with the new features of Excel.

2. Whether, once a cycle plot has been created, the data can be appended and the cycle plot updated without having to do any adjustments each time I update something.

3. I'd like to be able to study the cycle plot seasonality of many stocks, so I'm hoping simply refreshing with new or different stock would mean any data could be 'seasonlised'(!) without having to customise the data every single time.

4. The best direction to go to make this possible within Excel.

I've just started listening to Excel podcasts so that's how I discovered the new-ish features of Excel and thought about cycle plots.

Hope someone can help point me in the right direction.

Many thanks

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Watch MrExcel Video

Forum statistics

Latest member