This is so cool!! Thank you for the tutorial - I’m relatively new to the magic of spreadsheets, but it seems like every day I learn another cool formula trick. Is it possible to nest/stack this effect? Like, can I use something like this to compare a two data ranges to each other in a single graph?
I'll have to sit down and look through this more thoroughly, I'm trying to create three different data validation cells that all interact with each other, but I'm having a hard time grasping it. Something like (Data Validation) Maintenance, Cutting, Bulking which impact the results of another two sets of 3 data validation tables (Data Validation) High Carbs, Low Carbs, Moderate Carbs (Data Validation), low activy, moderate activity, heavy activity
Thank you very much for the video. Can you do a video on how to analyse student data using Looker Studio, blending the SEN and academic data for both class performance and individual performance.
Very helpful video lesson. Thank you for sharing your knowledge. I implemented it into my day trading journal to update my weekly and quarterly trading report cards.
This is cool. I want to create a dynamic chart in that the colours of the bar change dynamically when the values on the y-axis attain a particular threshold/value. Would you have any thoughts on how to achieve this?
Hi I just found your video and you solve my problem. I have a tax return from fuel in EU countries. With your help I can see how much I have according to the country. Thank you very much
Is it possible to add a dynamic chart title too? let's say, by linking the chart title to a dynamic cell using =[cell] I've tried it but didn't work, so maybe there's another way of doing that? (make a dynamic chart title)
Do you also know if you can change the background (and font) of a table diagram? Seems that that one is the only chart available without the option to change the background etc...
How do I change the color of individual bars when I pull up a dynamic chart so that the specific color is specific to one bar on a chart but not a different chart?
suppose we have two columns, col A and col B. From col A, I should be able to select A1, and this will automatically filter my range of choices in col B, I should be able select B2A1. Is this possible?
I feel like you've answered this question but even after watching all your videos I still can't figure it out! I want to have multiple names in a drop down and have the information in the cells below it change depending on what name is selected. Hoping you can help!
This can be achieved by having all the info in the table and then using a slicer to filter the data on name. That way only the selected names will show.
What if I want to create a chart that could change according to the date range. I mean I can do the same process as above. It won't tell me about any specific date range I want to see. Please help.
Perimeter = the phsyical length measure "around" something, like the "perimeter of a square" or "perimeter of a circle". The word you mean is "parameter" = the input argument value of a function, like the "2nd parameter of the vlookup function".
After I type in FALSE the cell closes and give the code: #REF! and a popup tab that reads: Error VLOOKUP evaluates to an out of bounds range., how do I correct that?
This video did not explain at all how you link the chart titles to the cell. In my Google Sheets the chart titles don't change when you change the name of the person. Nowhere on the internet can I find a link that explains how you can link the chart title to a cell in Google Sheets, so it would have been nice if you had explained it. You have not explained any of the details of the actual chart.
Jesus is God & He loves you Jesus will soon be seen by all men, women, and children in the clouds. Jesus is returning now! Believe and be saved. Exodus 3:14 (God speaking) And God said unto Moses, I AM THAT I AM: and he said, Thus shalt thou say unto the children of Israel, I AM hath sent me unto you. John 8:58 (Jesus speaking) Jesus said unto them, Verily, verily, I say unto you, Before Abraham was, I am.- John 10:30 (Jesus speaking) I and my Father are one. Isaiah 9:6 For unto us a child is born, unto us a son is given: and the government shall be upon his shoulder: and his name shall be called Wonderful, Counsellor, The mighty God, *The everlasting Father,* The Prince of Peace.- Matthew 1:23- Behold, a virgin shall be with child, and shall bring forth a son, and they shall call his name Emmanuel, which being interpreted is, *God with us.* John 1:1 & 14 1 In the beginning was the Word, and the Word was with God, and the Word was God. 14 And the Word was made flesh (Lord Jesus), and dwelt among us, (and we beheld his glory, the glory as of the only begotten of the Father,) full of grace and truth. John 8:24 (Jesus speaking) I said therefore unto you, that ye shall die in your sins: for if ye believe not that I am he, ye shall die in your sins. John 14:9 (Jesus speaking) Jesus saith unto him, Have I been so long time with you, and yet hast thou not known me, Philip? he that hath seen me hath seen the Father; and how sayest thou then, Show us the Father? Hebrews 1:1-3, & 8 (God calls His Son "O God" because Jesus IS God in the flesh) 1 God, who at sundry times and in divers manners spake in time past unto the fathers by the prophets, 2 Hath in these last days spoken unto us by his Son, whom he hath appointed heir of all things, by whom also he made the worlds; 3 Who being the brightness of his glory, and the express image of his person, and upholding all things by the word of his power, when he had by himself purged our sins, sat down on the right hand of the Majesty on high; 8 But unto the Son he saith, Thy throne, O God, is for ever and ever: a sceptre of righteousness is the sceptre of thy kingdom. 1 John 5:7 For there are three that bear record in heaven, the Father, the Word, and the Holy Ghost: and these three are one. Titus 2:13 Looking for that blessed hope, and the glorious appearing of the great God and our Saviour Jesus Christ; Revelation 1:7 Behold, he cometh with clouds; *and every eye shall see him,* and they also which pierced him: and all kindreds of the earth shall wail because of him. Even so, Amen.- Isaiah 44:6 (God speaking)- Thus saith the LORD the King of Israel, and his redeemer the LORD of hosts; I am the first, and I am the last; and beside me there is no God. Revelation 1:8 (Jesus speaking) I am Alpha and Omega, the beginning and the ending, saith the Lord, which is, and which was, and which is to come, *the Almighty.* Revelation 22:13 (Jesus speaking) I am Alpha and Omega, the beginning and the end, the first and the last. --- There Are None Righteous / How To Be Saved Romans 3:10 & 23 10 As it is written, There is none righteous, no, not one: 23 For all have sinned, and come short of the glory of God; Luke 5:31-32 (Jesus speaking) 31 And Jesus answering said unto them, They that are whole need not a physician; but they that are sick. 32 I came not to call the righteous, but sinners to repentance. 1 Peter 3:18 (The word “quicken” means “to make alive”) For Christ also hath once suffered for sins, the just for the unjust, that he might bring us to God, being put to death in the flesh, but quickened by the Spirit: Romans 10:9 That if thou shalt confess with thy mouth the Lord Jesus, and shalt believe in thine heart that God hath raised him from the dead, thou shalt be saved. Acts 4:12 Neither is there salvation in any other: for there is none other name under heaven given among men, whereby we must be saved. Ephesians 2:8-9 8 For by grace are ye saved through faith; and that not of yourselves: it is the gift of God: 9 Not of works, lest any man should boast. Repent of your sins or suffer the consequences. Lord Jesus died in our places personally to take the death punishment that sin deserves and then resurrected by the power of God. Believe this and sincerely repent of your sins each time you sin and you will have eternal life and nothing to fear. Fail to repent and you will end up in the Lake of Fire.
Appreciate you taking the time to comment. I'm always trying to develop the content to be as informative and helpful as possible and am continuously making changes to hopefully make it better each video.
I want to link this to a poll using google sheets! This was very helpful, thank you! (I'm currently bingeing on your channel)
This is so cool!! Thank you for the tutorial - I’m relatively new to the magic of spreadsheets, but it seems like every day I learn another cool formula trick.
Is it possible to nest/stack this effect? Like, can I use something like this to compare a two data ranges to each other in a single graph?
Your tutorials are super useful. I've got plenty of ways that I'm going to use this. Thanks.
Great info, thanks!
Glad you liked it
I'll have to sit down and look through this more thoroughly, I'm trying to create three different data validation cells that all interact with each other, but I'm having a hard time grasping it.
Something like
(Data Validation) Maintenance, Cutting, Bulking
which impact the results of another two sets of 3 data validation tables
(Data Validation) High Carbs, Low Carbs, Moderate Carbs
(Data Validation), low activy, moderate activity, heavy activity
Very helpful video! I used it for visualizing yearly financials
Glad it was helpful!
Thank you very much for the video. Can you do a video on how to analyse student data using Looker Studio, blending the SEN and academic data for both class performance and individual performance.
Very helpful video lesson. Thank you for sharing your knowledge. I implemented it into my day trading journal to update my weekly and quarterly trading report cards.
This is cool. I want to create a dynamic chart in that the colours of the bar change dynamically when the values on the y-axis attain a particular threshold/value. Would you have any thoughts on how to achieve this?
Hi I just found your video and you solve my problem. I have a tax return from fuel in EU countries. With your help I can see how much I have according to the country. Thank you very much
This answered my confusion. Thank you!
This makes me a solution for my dashboard, Thanks.
What I wanted exacltly... Superb video... Thank you so much brother
very good....thank you for your explanation
Thank you!
Is it possible to add a dynamic chart title too? let's say, by linking the chart title to a dynamic cell using =[cell]
I've tried it but didn't work, so maybe there's another way of doing that? (make a dynamic chart title)
same question
I want to build an income tax calculator. This function will be very useful indeed. Awesome illustration. Thanks.
Thank you!
Thank you. I was looking for this solution👍👍
Glad it helped you! Have you looked at Data studio yet?
@@FlippedClassroomTutorials not yet. What is it?
A fully dynamic/interactive dashboard and report creator based on Sheets. Will do some videos on it as it is very powerful!
@@FlippedClassroomTutorials I'll be grateful for that
Many thanks 🤩🤩🤩
Cool 😎 Thx! 👍
I'm looking at creating _"User Select"_ dynamic charts for trigonometric, polor, et al. equations. Hopefully, that is... lol
thank you
Do you also know if you can change the background (and font) of a table diagram? Seems that that one is the only chart available without the option to change the background etc...
How do I change the color of individual bars when I pull up a dynamic chart so that the specific color is specific to one bar on a chart but not a different chart?
This genius!
suppose we have two columns, col A and col B. From col A, I should be able to select A1, and this will automatically filter my range of choices in col B, I should be able select B2A1. Is this possible?
Thanks a bunch
Happy it helps!
how to add dynamic header in google sheet please do video on that
all good! However when yo make the dynamic chart the vertical axis changes. How can I keep it fixed? for example 0% - 100%
Can I navigate to another chart by clicking on a portion of the first chart using google sheets?
I feel like you've answered this question but even after watching all your videos I still can't figure it out! I want to have multiple names in a drop down and have the information in the cells below it change depending on what name is selected. Hoping you can help!
This can be achieved by having all the info in the table and then using a slicer to filter the data on name. That way only the selected names will show.
What if I want to create a chart that could change according to the date range. I mean I can do the same process as above. It won't tell me about any specific date range I want to see. Please help.
Perimeter = the phsyical length measure "around" something, like the "perimeter of a square" or "perimeter of a circle". The word you mean is "parameter" = the input argument value of a function, like the "2nd parameter of the vlookup function".
How to have the chart and dropdown menue only in another sheet? I do want the source data in the same sheet.
how to publish this type of excel cos if you give editor access to all then-existing
value may be changed
How do we create zoomable interactive chart in google sheets?
Can you tell that how can make a chart in another worksheet if my data lies in other worksheet?
How can I update the chart title based on a cell value?
hi, how do we prevent the charts from being edit by the other editors?
Hi can you have a chart title linked to a cell like you can in Excel?
After I type in FALSE the cell closes and give the code: #REF! and a popup tab that reads: Error
VLOOKUP evaluates to an out of bounds range., how do I correct that?
สวัสดีครับ สุดยอดครับ
This video did not explain at all how you link the chart titles to the cell. In my Google Sheets the chart titles don't change when you change the name of the person. Nowhere on the internet can I find a link that explains how you can link the chart title to a cell in Google Sheets, so it would have been nice if you had explained it. You have not explained any of the details of the actual chart.
I'm also looking for this possibility. But besides that the use of data validation to create dynamic sheets is really cool.
👍
Jesus is God & He loves you
Jesus will soon be seen by all men, women, and children in the clouds. Jesus is returning now! Believe and be saved.
Exodus 3:14 (God speaking)
And God said unto Moses, I AM THAT I AM: and he said, Thus shalt thou say unto the children of Israel, I AM hath sent me unto you.
John 8:58 (Jesus speaking)
Jesus said unto them, Verily, verily, I say unto you, Before Abraham was, I am.-
John 10:30 (Jesus speaking)
I and my Father are one.
Isaiah 9:6
For unto us a child is born, unto us a son is given: and the government shall be upon his shoulder: and his name shall be called Wonderful, Counsellor, The mighty God, *The everlasting Father,* The Prince of Peace.-
Matthew 1:23-
Behold, a virgin shall be with child, and shall bring forth a son, and they shall call his name Emmanuel, which being interpreted is, *God with us.*
John 1:1 & 14
1 In the beginning was the Word, and the Word was with God, and the Word was God.
14 And the Word was made flesh (Lord Jesus), and dwelt among us, (and we beheld his glory, the glory as of the only begotten of the Father,) full of grace and truth.
John 8:24 (Jesus speaking)
I said therefore unto you, that ye shall die in your sins: for if ye believe not that I am he, ye shall die in your sins.
John 14:9 (Jesus speaking)
Jesus saith unto him, Have I been so long time with you, and yet hast thou not known me, Philip? he that hath seen me hath seen the Father; and how sayest thou then, Show us the Father?
Hebrews 1:1-3, & 8 (God calls His Son "O God" because Jesus IS God in the flesh)
1 God, who at sundry times and in divers manners spake in time past unto the fathers by the prophets,
2 Hath in these last days spoken unto us by his Son, whom he hath appointed heir of all things, by whom also he made the worlds;
3 Who being the brightness of his glory, and the express image of his person, and upholding all things by the word of his power, when he had by himself purged our sins, sat down on the right hand of the Majesty on high;
8 But unto the Son he saith, Thy throne, O God, is for ever and ever: a sceptre of righteousness is the sceptre of thy kingdom.
1 John 5:7
For there are three that bear record in heaven, the Father, the Word, and the Holy Ghost: and these three are one.
Titus 2:13
Looking for that blessed hope, and the glorious appearing of the great God and our Saviour Jesus Christ;
Revelation 1:7
Behold, he cometh with clouds; *and every eye shall see him,* and they also which pierced him: and all kindreds of the earth shall wail because of him. Even so, Amen.-
Isaiah 44:6 (God speaking)-
Thus saith the LORD the King of Israel, and his redeemer the LORD of hosts; I am the first, and I am the last; and beside me there is no God.
Revelation 1:8 (Jesus speaking)
I am Alpha and Omega, the beginning and the ending, saith the Lord, which is, and which was, and which is to come, *the Almighty.*
Revelation 22:13 (Jesus speaking)
I am Alpha and Omega, the beginning and the end, the first and the last.
---
There Are None Righteous / How To Be Saved
Romans 3:10 & 23
10 As it is written, There is none righteous, no, not one:
23 For all have sinned, and come short of the glory of God;
Luke 5:31-32 (Jesus speaking)
31 And Jesus answering said unto them, They that are whole need not a physician; but they that are sick.
32 I came not to call the righteous, but sinners to repentance.
1 Peter 3:18 (The word “quicken” means “to make alive”)
For Christ also hath once suffered for sins, the just for the unjust, that he might bring us to God, being put to death in the flesh, but quickened by the Spirit:
Romans 10:9
That if thou shalt confess with thy mouth the Lord Jesus, and shalt believe in thine heart that God hath raised him from the dead, thou shalt be saved.
Acts 4:12
Neither is there salvation in any other: for there is none other name under heaven given among men, whereby we must be saved.
Ephesians 2:8-9
8 For by grace are ye saved through faith; and that not of yourselves: it is the gift of God:
9 Not of works, lest any man should boast.
Repent of your sins or suffer the consequences. Lord Jesus died in our places personally to take the death punishment that sin deserves and then resurrected by the power of God. Believe this and sincerely repent of your sins each time you sin and you will have eternal life and nothing to fear. Fail to repent and you will end up in the Lake of Fire.
PLS SHOW CHARTS IN A LARGER SCREEN SPACE..NOT YOUR FACE. rEST VIDEO IS INFORMATIVE
Appreciate you taking the time to comment. I'm always trying to develop the content to be as informative and helpful as possible and am continuously making changes to hopefully make it better each video.