If you wanted to get fancier then the ordinary pie charts how about making a 3D pie chart that has the slices come out from the center. In this video, I'll cover how to create a pie chart with an exploding pie slice. Also covering how to change the rotation and adding some 3D effects.
Wednesday, July 24, 2019
Tuesday, July 23, 2019
Calculate the Interest Rate on a Car Loan
Use the Excel RATE Function to calculate the annual interest rate. This will give you an idea how much interest you are paying if you change the monthly amount or number of payment periods.
Monday, July 22, 2019
Create a Stock Chart
Are you tracking a stock investment and wanted to see how it's trending over a period of time? But not just happy looking at numbers in a table? Well create a chart....more specifically create a stock chart! This type of chart will let you look at the trend of high/low/open/close price of a stock over a period of time and let you visually see how it's been faring. Did you also know this type of chart is as old as dirt? The concept of the stock charts takes from candlestick charts which were supposedly created in 18th century in Japan by a rice trader. So when creating your stock chart, you'll be in good company knowing that it's origin had the same purpose as it does today - to track investments. See the video on how to create the stock chart.
Subscribe to:
Posts (Atom)