Learn how to Create Index charts in Excel to compare data

in hive-196037 •  4 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

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  
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