Learn how to Create Index charts in Excel to compare data

#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
• How to get historic Cr...
learn more about data types
• Rich Data Types in Exc...
Connect to coinmarketcap API
theexcelclub.c...
Index Charts, Part 1: Making Time Series Data Comparable
• Index Charts, Part 1: ...

[@financebr]

TY!! HELPED ME A LOT, im applying for an internship and one of the tastks that ive made i used your video. literally saved me.

[@AllenAnand]

ABSOLUTELY SAVED ME.......THANK YOU SO MUCH FOR YOUR EFFORTS 😇🤗

[@lukeyb5099]

You saved my assignment, you're the best.

[@amulpatel]

Very helpful ty

[@pedrocotta8320]

Excellent video, Paula. This is exactly what I was looking for. Thanks.

[@sluke360ee1]

Thank you Paula - very helpful!

[@aslihanakar1926]

I think it's a great way to visualize. May be we can use logarithmic scale to see the others, too.

[@PaulaWeb3andCrypto]

100%

[@mbasurtos]

Beautiful accent! Thanks for the video!

[@wayneedmondson1065]

Hi Paula. Very interesting analysis and charting technique. Will come in handy. Thanks for sharing it :)) Thumbs up!!

[@RijekaDnB]

Amazing Paula, really helpful!

[@PaulaWeb3andCrypto]

thanks

[@ramanbansal5387]

good... very good... video... very easy to understand... thanks..

[@view1989]

Thanks very helpful!!!...

[@bhardwajism]

Thank you Paula

[@maramben4618]

you saved my life

[@shabanshah7039]

Thank u mam! I really want to learn with u. Very helpful.

[@LicoInvestments]

Nice chart. Thanks!

[@selfchanger5149]

Amazing! Thank you very much

[@katon361]

Nice, thank you!!!

[@user-lr6vx1kr8v]

Hi Paula, great video thanks, very clearly explained. Is there a way to create an adjustable timescale across this data? i.e. one that re-indexes to 100 from whatever start date you choose?

[@IamXAbhi111]

Thank you. How to create, displacements and load with multiple samples

[@Daniel-dx3be]

This is fantastic

[@SSM_33]

thanx

[@abdalqadr1]

تمام

[@djb5320]

Thanks

[@sandrokich]

Great!

[@paulmacharia4210]

Hey Paula thanks for the video..can you do one of creating a seasonality index for bitcoin for the past 10 years... love from🇰🇪

[@homerdus9668]

would you like to make one excel
that compares two wallets how the are performing including
- summarizing daily performance of a trading transactions (crypto pairs) during x months
- showing/comparing trend of wallet1 and wallet2
- in USD
there can be several transactions per day, so all transactions during a days have to summarized and all converted to USD (that day value)
- transaction data can be imported from Exchange (e.g. Binance ),
- crypto valuations from yahoo finance (if there is older excel in use)
trick is really optimally combining data from two wallets and comparing their performance.

[@aksingh11]

thanks for the video .i was wondering if we can create an index or portifolio of stocks which records the value of the portfolio every end of day ?

[@djb5320]

theres a stock history function that you can use with the Stock data type in excel which can do this

[@tommyharris5817]

How do you convert the 100 base value to 0%?

[@fadibataineh2379]

Queen