Thank you so much mate, it was really helpful. Loved your point-wise explanation. Keep on posting new videos, guys like you are really needed. Thanks a bunch bro!

I am glad that you liked it!

I am glad that you like it!

Very helpful and easy to follow. Needed it for a client report and looks great. Thank you!

Excel is awesome and you are clearly demonstrating that. Thank you for your help!

I am glad that it helped!

DUDE! U R so awesome. Thank you so much for this. Seriously, I spent 3 days on a homework assignment trying to figure this out and in 20 seconds after seeing your video, I resolved and finished the assignment. YOU ARE THE BEST. EASY SUBSCRIBE.

Thank YOU!!! for posting this video- I can't tell you how much time and frustration you saved me- thank you, thank you, thank you!!!!!!!!

I can't believe this 12 year old video helped me out more than my professor, my TA, or any recent excel tutorial

Glad you like it!

Thank you --you have made my day alive with good lesson.

Every now and then I stumble on a formula that I forgot about or should have been using. The percent of change formula you used in this video is one I had forgotten about, but will start using againg. Thanks!! I typically use the =(NewAmount-OldAmount)/OldAmount to get my percent of total, but your formula is much more efficient. Appreesh my friend!!

أعجبت جداً بطرحتك الراقي ، وتنظيمك. i like what you do so much . thank you a lot and please note that someone from Saudi Arabia best wishes for you always.

You are welcome!!! Thanks for the 5 star rating!!

@teohais , glad that you like it!!

Thank you so much for posting this video. I would never have figured it out. Lifesaver!

Great video ! You explained that so well ! Much appreciated

@tillchelsea , you are welcome!

Thanks, I changed the description!!

That's brilliant ! Thanks very much. Simon.

However, I may have been incorrect in my language in the video by using the term percentage. But the bottom line, when you see the number 0.12 or the percentage 12%, the machine uses only the 0.12 for calculating and the 12% is not a number it is a formatted symbolic representation of a number.

@pliskiniroquis , mathematically (End-beg)/beg is the same as End/Beg - 1.

THANK YOU. This video was the perfect solution to my excel chart issue. Thumbs Up and Subbed.

Thank you for this you made my task a lot easier!

Thank you so much sir. It really very helpful for me. Your videos work as a doramon gadgets for me. Thank you again😁

You saved my life. Bless you!

You are just amazing! Thank you!

You are welcome!!!

awesome video, your efforts are highly appreciated

Dear PrincessWithSkills, Everyday that I use Excel I am learning new things, and every other day, I think to myself, "I am not sure that I even know a little bit about Excel!!!" That is how much there is. But this is good -- We'll always have fun learning new things. --excelisfun --excelisfun

You are welcome!

Thanks! Just what I needed :)

Excellent!!! Thank you so very much

Try right-clicking the axis and point to Format, then there should be settings to do what you want.

I'm still using this trick on a regular basis. So useful! 😉

Nice explanation. Thank you very much.

Thank you so much! It helped!

Hi Sungwan and thank you. I am wondering how you would go about adding for example the tax amount for each month and (should there have been a change in the %) show the change . When I try, the markers go in between the column graphs. i would like to keep them bang in the middle. Otherwise the graph does not make sense. Help appreciated.

Thank you! really helpful...

absolutely cool video, much so much

Thank you so much , your video was of so much help

OMG !!! Incredible !!!

you are the KING.

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.

AWESOME!! Thank you for the magic!

Thank you sir, it really helpful :)

Awesome !! Thanks

Very True!

your video very helpfull to me.. tq soo much..

ur one of the best human in world :) grt free service

Thank you!

Excellent video thanks a lotb

thanks))) this is video so useful

This was very good one...

Great video. Question do you have a video for something with three data series and two chart types?

Sir ! I would like to know if my Chart replaced by year instead of month, so how I can do that?

Hi , when i am using % change, getting error#value!..Could you pls tell me what format i should select ?

thanks ! What to do? if you have some values in your table equal 0 you can not divide any number by zero

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?

14 years ago and still helpful thank you

very nice teacher. Thanks

You are so talented and knowledgeable!

I LOVE YOU MAN SAVE MY LIFE...

great and thanks a lot buddy

Awesome video and a great reminder as to why Excel is such an essential business tool! Quick question for you: I do everything EXACTLY as instructed, but the months end up showing in the middle of the graph instead of as a legend at the bottom. I can't figure it out. Suggestion?

thanks a lot!!!

Pretty clear

Help!! I need to graph time on the y axis and date on the x axis and my graph is all messed. For example, on 2/15/17 resident woke up at 3:30AM and 4:30AM, on 2/16/17, resident woke up at midnight.

Thank you very much.

Thank you very very very very very very very very much!!!!!!!!!!!!!!!!!!!!!

thanks so much...

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.

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

hey, I'm having some problems analyzing some experimental data. I'm trying to get peak values from the graphs that I'm generating but to no avail. once i obtain these peak values I need to get the corresponding values that are 5% above and 5% below those peak values. could you offer some assistance?( is excel capable of giving me this peak value?)

Great Info. Thanks.

thanks alot.

Thank you for making my life easy.

thanks my brother 👊🇹🇿

Nice vdos.

If I have dry/reefer cost of freight by carrier month after month for certain regions of the country and I want to see the % change in cost how can I put a chart together to see what the increase is?

Thank you vary much.♥️

I put off upgrading to 2007. Eventually had to, and could not figure out how to do many things that I could do in Excel 2003. Thanks for your videos!

Dear PrincessWithSkills, But I have never taken the MS Excel Expert Exam!! Have you taken that exam? Maybe I should try it some time (but just because Excel is so much fun!). --excelisfun

Thats a useful formula. I'm interested in using a variant - percentage change from the zero day rather than from the previous cell in the series. Would you know the formula for that?

thx alot bro

Hi There, Can you please explain . why are we using -1 after End Value/Beg Value Thanks in advance ...

good job

thanks

thanks sir

IS it possible to create a dynamic percentage change like the way you did for the creating a dynamic index function? Basically, I would like excel to automatically compute the percentage change for YoY change over past 3 years (for example, changes between Y1and Y2, Y2 and Y3, Y3 and Y4) as I add continually add the data?thanks

Infact every excel lover has a lot of fun with excel

Hey ExcellsFun i need a help from you , i need to know how to alarm me excel when one formula change , do u understand , when change the color or something i need really help please.

I do not know how to do that. Maybe VBA code. Try THE best Excel question site: mrexcel [dot] com/forum

I have a chart like this, but everytime I put new data, the labels (with percentages) dont all automatically update. Do you know what the solution for that is

Thanks for the video! BTW, there's a typo in the Video Description's percent change formula. (It's missing the minus sign.)

Nice

What about data table? How can we change the signs (percentage or currency) with data table in the chart?

Thanks for being a great teacher and for using Excel 2007. I'm not going to update my excel because I want to keep using Windows 7 and newer versions of excel don't work on this Windows.

what is that -1 for? Was it referring to the "current month"-1?

whats the meaning of series 1, series 2? is it name of the columns in excel?