Excel Magic Trick # 267: Percentage Change Formula & Chart

Download file in "Excel Magic Trick" section: https://people.highline.edu/mgirvin/excelisfun.htm Learn about the universal formula for Percentage Change: (End Value)/Beg Value) - 1 = Percentage Change. The see how to create and format a chart with two data series and two chart types in one chart: Line Chart and Column Chart.


  1. You are just amazing! Thank you!
  2. good job
  3. Can u mail me some dashboards for advance excel.
  4. thanks <3
  5. how did he get 13?
  6. Thanks! Just what I needed :)
  7. I created an Excel Table in Word and then created the graph in Excel like you outlined HOWEVER, the Chart doesn't save into Word with my table. All I see is the table. Is there a way that the Chart will save in Word, below the Table as it does in Excel directly?
  8. You are so talented and knowledgeable!
  9. absolutely cool video, much so much
  10. thanks sir
  11. Thank you --you have made my day alive with good lesson.
  12. I forgot to ask. How to create a dual axis chart? where the primary is column and secondary is line but don't show the primary if the secondary is null. Thanks.
  13. Thank you so much for your tutorial it was very helpful. I took excel expert but I was not able to create the dual axis chart. the chart has the primary axis as column and the secondary as line. the chart has to show only where the two chart has value but if the secondary has 0 as value don't show the column data of the primary. Thank you so much.
  14. Thank you sir, it really helpful :)
  15. your video very helpfull to me.. tq soo much..
  16. thanks !
    What to do? if you have some values in your table equal 0
    you can not divide any number by zero
  17. Nice vdos.
  18. It's great video but one thing which is bothering me is what if i want to add date label and remove junk from both the axis ........it doesn't work, could you pl look in to that........Thanks
  19. Thank you so much sir. It really very helpful for me. Your videos work as a doramon gadgets for me. Thank you again😁
  20. Nice

Additional Information:

Visibility: 557207

Duration: 6m 41s

Rating: 1324