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!!
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.
أعجبت جداً بطرحتك الراقي ، وتنظيمك. i like what you do so much . thank you a lot and please note that someone from Saudi Arabia best wishes for you always.
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.
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
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!
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 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.
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.
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
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?
That is not correct. (a/b-1)*100 is a formula that was invented before calculators. The *100 is just for the facade: it is just a formatting that you use on paper. In calculators and Excel, when you apply the % format, the decimal number is still being used by the code underneath. 0.12 is a number. 12% is a symbolic formatted representation of the number 0.12. As an example, does 0.12 = 12? The answer is FALSE. So when you multiple a/b-1*100 you are fundamentally changing the number.
Dear capodaughter, Thanks! But I am not the best with Excel (the best are at the Mr Excel Message Board), but I am a guy Having Fun With Excel!! --excelisfun
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.
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
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.
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?
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?
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
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.
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?)
I can't believe this 12 year old video helped me out more than my professor, my TA, or any recent excel tutorial
I got your back ; ) I also have over 3,300 other Excel videos - just search the channel : ) Or ask.
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!!
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.
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 like what you do so much . thank you a lot and please note that someone from Saudi Arabia best wishes for you always.
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.
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
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!
Excel is awesome and you are clearly demonstrating that. Thank you for your help!
I am glad that you liked it!
I am glad that you like it!
Thank you for making my life easy.
You are welcome!
14 years ago and still helpful
thank you
I'm still using this trick on a regular basis. So useful! 😉
THANK YOU. This video was the perfect solution to my excel chart issue. Thumbs Up and Subbed.
thanks my brother 👊🇹🇿
You are welcome!
Thank you so much for posting this video. I would never have figured it out. Lifesaver!
You are welcome!!!
Thanks for the 5 star rating!!
Thank you very very very very very very very very much!!!!!!!!!!!!!!!!!!!!!
+Sinethemba Nontshintshi You are welcome!
Glad you like it!
Try right-clicking the axis and point to Format, then there should be settings to do what you want.
I am glad that it helped!
Great video ! You explained that so well ! Much appreciated
Thank you --you have made my day alive with good lesson.
Thank you for this you made my task a lot easier!
You are welcome!
You saved my life. Bless you!
@tillchelsea , you are welcome!
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!
@teohais , glad that you like it!!
Thank you vary much.♥️
You are welcome so much!!!
You are welcome!!
@pliskiniroquis , mathematically (End-beg)/beg is the same as End/Beg - 1.
Thanks, I changed the description!!
ur one of the best human in world :) grt free service
You are so talented and knowledgeable!
I hope the videos helped, Creighton!!!!
Thank you so much sir. It really very helpful for me. Your videos work as a doramon gadgets for me. Thank you again😁
you are the KING.
That's brilliant ! Thanks very much. Simon.
Very helpful and easy to follow. Needed it for a client report and looks great. Thank you!
Excellent video thanks a lotb
Infact every excel lover has a lot of fun with excel
Very True!
I LOVE YOU MAN SAVE MY LIFE...
Thank you!
very nice teacher. Thanks
Pretty clear
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?
awesome video, your efforts are highly appreciated
Excellent!!! Thank you so very much
Nice explanation. Thank you very much.
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.
I try to be a one-stop shopping channel: new, old, basic, advanced and lots of fun : )
@@excelisfun
Glad you replied to my comment.
Many of the other channels are only focusing on the newer versions of excel.
@@steniorodrigo5590 Well, after 14 years at TH-cam I do have a lot of videos covering a lot of different versions lol
Thank you very much.
You are welcome!
ExcelIsFun the UK and
Thank you so much , your video was of so much help
You are just amazing! Thank you!
Great Info. Thanks.
You are welcome!
This was very good one...
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.
your video very helpfull to me.. tq soo much..
AWESOME!! Thank you for the magic!
Great video. Question do you have a video for something with three data series and two chart types?
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
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?
Thanks! Just what I needed :)
absolutely cool video, much so much
Thank you so much! It helped!
Thanks for the video! BTW, there's a typo in the Video Description's percent change formula. (It's missing the minus sign.)
Thank you! really helpful...
Wow
Glad you liked it, SORIF!!!!
That is not correct. (a/b-1)*100 is a formula that was invented before calculators. The *100 is just for the facade: it is just a formatting that you use on paper. In calculators and Excel, when you apply the % format, the decimal number is still being used by the code underneath. 0.12 is a number. 12% is a symbolic formatted representation of the number 0.12. As an example, does 0.12 = 12? The answer is FALSE. So when you multiple a/b-1*100 you are fundamentally changing the number.
Dear capodaughter,
Thanks! But I am not the best with Excel (the best are at the Mr Excel Message Board), but I am a guy Having Fun With Excel!!
--excelisfun
thanks !
What to do? if you have some values in your table equal 0
you can not divide any number by zero
great and thanks a lot buddy
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 sir, it really helpful :)
thanks))) this is video so useful
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
Awesome !! Thanks
What about data table? How can we change the signs (percentage or currency) with data table in the chart?
OMG !!! Incredible !!!
thanks a lot!!!
whats the meaning of series 1, series 2? is it name of the columns in excel?
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.
thanks so much...
You're a legend sir.
thanks a lot for your help
Is there a video on how to produce percentage bar chart?
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?
How to place %change between Jan and Feb Bar???
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?
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
good job
Hi There,
Can you please explain . why are we using -1 after End Value/Beg Value
Thanks in advance ...
thx alot bro
thanks alot.
yes.
what is that -1 for? Was it referring to the "current month"-1?
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.
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?)
Hi , when i am using % change, getting error#value!..Could you pls tell me what format i should select ?
Nice vdos.