Learn how to Create Index charts in Excel to compare data

in DTube4 years ago


#excel #charts #visulisations

In this video, you will learn how to create an Index chart in Excel. An index chart is a great chart to compare trends against different sets of data. In this video, we will compare the price movement trend of four popular cryptocurrency prices. You will see how using a standard line chart can make it difficult to see similar patterns and trends between data sets and how using an index chart you can overcome this.

learn more about the stock history function in Excel

learn more about data types

Connect to coinmarketcap API
https://theexcelclub.com/how-to-connect-excel-to-coinmarketcap-api/

Index Charts, Part 1: Making Time Series Data Comparable

Sort:  
Saludos, @paulag, Interesante la Hoja de Cálculo Excel. Me gustan sus Herramientas de Tablas Dinámicas, Filtro Avanzado, Consolidar Datos, Función Objetivo, Escenarios, Vinculación Interna y Externa, entre tantas otras herramientas de Excel. Felicitaciones por la Tarea didáctica de presentar lecciones de esta tan importante herramienta. Que tengas Feliz Noche. Atentamente, @warrenjemkis desde Venezuela.

:-) thanks for watching, I am glad you like Excel

Coin Marketplace

STEEM 0.20
TRX 0.12
JST 0.028
BTC 63721.78
ETH 3503.08
USDT 1.00
SBD 2.54