In fact I just don't know how to thank you for this amazing tutorials. Your tutorials have helped me to grow my channel. I was able to develop a school management system in excel and it's just trending. Once again thank you very much sir
Hey! Thank you so much for the video. Very useful! I was wondering if it is possible to also have the legend in the graphs appear/disappear by checking the boxes. This would be useful when dealing with many traces to avoid the legend taking excessive space if it always includes all the traces names. Thanks!
Put this formula in A20 at 7:38: =IF(B12, A4:E4,"") It's not a perfect solution, but at 7:38 if instead of hardcoding your legend labels (i.e., Netflix, Disney, etc.) in cells A20:A23, start your "IF" statement there, and include column A in your range you want to grab if the checkbox is checked. Additionally, instead of not specifying the third argument in the IF statement, make it a blank if false: " ". This will only make the words on the legend disappear, not the little line symbol. But at least it's easier to see which one's are on your graph. Hope this helps.
Hullo Jamie...Very interesting and useful video, Thank You...! But in my Excel, there is no "customize ribbon"... Is that a version issue, I have 2007...? Greetings.
How do you hide the labels of the unchecked rows? In your graph, it still shows Netflix, Disney+, TikTok and RUclips in the legend, even if they're unchecked. And if you use a different type of graph, where it's labels vs. values, then the labels are still there. Is there a way to have it that the checkbox completely removes the row? So that if you uncheck NetFlix, for example, it's just not included in the chart at all. Not just the values - the line - but not in the legend and not on the other axis, for other types of charts that show this? An actual checkbox that includes / excludes that whole row from the charts completely. That the checkbox adds / removes it as a data source, essentially. How would you do that in Excel?
By chance do you offer private tutoring? I have something extremely neat I'm working on and I think 30 minutes with you would solve the one thing I've been stuck on the past month. Willing to pay, I can keep it straight to the point out of respect for your time. What I'm building is truly pretty neat, I would love to share and see your thoughts. Thanks so much.
Hi. Nice set of XL tutorials. I’ve learnt so much from them. However, I record temperature, humidity and pressure hourly for each day of the year and consolidate all the data into a table for the year with column headings of Month, Day, Hour, Minute, Temp, Humid and Pressure, each year having its own table. I’d like to do 2 things:- 1. Extract, from this data, the temp, humid and pressure at mid-day and mid-night for each day of the year. So for each parameter I have 2 x 365 values. Then 2. Present this data on a chart using the check boxes to show either mid-day or mid-night values. I used to use XL quite a lot at work presenting tables and charts to my manager for analysis but, since retiring quite a few years ago, some of the skills I once had have melted away. Is this something you can help with please? Thank you and keep up the good work. Jim.
when I uncheck the box in the interactable chart (so it appears as false), the line for it is put as zero instead of disappearing from the chart, is there a way to make it disappear then reappear again after I check the box? instead of appearing on the bottom line as zero
I cannot get mine to do like yours in setting up check boxes and =if(b12,b4:e4) it only enters the first box info, not the range info, I"ve done this step by step entering the information as you did, putting vid on pause after each time and I can't get past that so I can't finish this tutorial
@MoniMeka @Y2JWannaBe3 I had the same issue but I found that if my bottom table is exactly the same column under the top one, then it works. If you move it like one column to the right/left, then it won't work.
I'm having the unfortunate problem of having excel graph a False as 0. is there any way around this? is there a way to make the value 0 if false, that way the graph can ignore 0?
@@dandiyuanaridianto4391 thanks for the reply I actually did the same as he did but it didn't work. The if statement gave me 7.16 when true. Not the 4 numbers (q1 to q4) . And when i dragged 7.16 downwards, it only gave me the q1 numbers. It only worked when i entered an if statement for each row independently.
@@lebanesedashcam553 i guess u using excel 2013 version too? So what i did is just i make an absolute reference to the logical_test then drag to the right til Q4. So for other row just do the same but make sure u absolute reference to correct cell.
In fact I just don't know how to thank you for this amazing tutorials. Your tutorials have helped me to grow my channel. I was able to develop a school management system in excel and it's just trending. Once again thank you very much sir
Glad you like it it. You’re welcome.
Been following you, and benefiting from your videos, for years. Thanks for your generosity in sharing your data so we can all play along.
Hey! Thank you so much for the video. Very useful! I was wondering if it is possible to also have the legend in the graphs appear/disappear by checking the boxes. This would be useful when dealing with many traces to avoid the legend taking excessive space if it always includes all the traces names. Thanks!
Following...
Put this formula in A20 at 7:38: =IF(B12, A4:E4,"")
It's not a perfect solution, but at 7:38 if instead of hardcoding your legend labels (i.e., Netflix, Disney, etc.) in cells A20:A23, start your "IF" statement there, and include column A in your range you want to grab if the checkbox is checked. Additionally, instead of not specifying the third argument in the IF statement, make it a blank if false: " ". This will only make the words on the legend disappear, not the little line symbol. But at least it's easier to see which one's are on your graph. Hope this helps.
Thnx alot for your tutorial and i can't wait to see the new up coming video 🔥
Hullo Jamie...Very interesting and useful video, Thank You...!
But in my Excel, there is no "customize ribbon"...
Is that a version issue, I have 2007...?
Greetings.
hello Mr. Jim Thank a lot for your tutorial
How do you hide the labels of the unchecked rows?
In your graph, it still shows Netflix, Disney+, TikTok and RUclips in the legend, even if they're unchecked. And if you use a different type of graph, where it's labels vs. values, then the labels are still there.
Is there a way to have it that the checkbox completely removes the row? So that if you uncheck NetFlix, for example, it's just not included in the chart at all. Not just the values - the line - but not in the legend and not on the other axis, for other types of charts that show this?
An actual checkbox that includes / excludes that whole row from the charts completely. That the checkbox adds / removes it as a data source, essentially.
How would you do that in Excel?
By chance do you offer private tutoring? I have something extremely neat I'm working on and I think 30 minutes with you would solve the one thing I've been stuck on the past month. Willing to pay, I can keep it straight to the point out of respect for your time. What I'm building is truly pretty neat, I would love to share and see your thoughts. Thanks so much.
the rage is not all fiiling when I use the if function. Only cell B20 is working please
What is the difference between this and a pivot chart? Isn't it possible to add slicers to a pivot chart?
Good Job!!!
Thanks!
Thank you 🙏🔥
Hi. Nice set of XL tutorials. I’ve learnt so much from them. However, I record temperature, humidity and pressure hourly for each day of the year and consolidate all the data into a table for the year with column headings of Month, Day, Hour, Minute, Temp, Humid and Pressure, each year having its own table. I’d like to do 2 things:- 1. Extract, from this data, the temp, humid and pressure at mid-day and mid-night for each day of the year. So for each parameter I have 2 x 365 values. Then 2. Present this data on a chart using the check boxes to show either mid-day or mid-night values. I used to use XL quite a lot at work presenting tables and charts to my manager for analysis but, since retiring quite a few years ago, some of the skills I once had have melted away. Is this something you can help with please? Thank you and keep up the good work. Jim.
Perfect!
when I uncheck the box in the interactable chart (so it appears as false), the line for it is put as zero instead of disappearing from the chart, is there a way to make it disappear then reappear again after I check the box? instead of appearing on the bottom line as zero
THANKS
I cannot get mine to do like yours in setting up check boxes and =if(b12,b4:e4) it only enters the first box info, not the range info, I"ve done this step by step entering the information as you did, putting vid on pause after each time and I can't get past that so I can't finish this tutorial
Yeah, it does the same thing for me. I only got the value for Netflix Q1.
same problem
@MoniMeka
@Y2JWannaBe3
I had the same issue but I found that if my bottom table is exactly the same column under the top one, then it works. If you move it like one column to the right/left, then it won't work.
I'm having the unfortunate problem of having excel graph a False as 0. is there any way around this? is there a way to make the value 0 if false, that way the graph can ignore 0?
The function (if) works for Q1 only. Weird
you only need to copy the if q1formula to the rest q cell by sell, and than you can drag them down, hope it helps
@@dandiyuanaridianto4391 thanks for the reply
I actually did the same as he did but it didn't work. The if statement gave me 7.16 when true. Not the 4 numbers (q1 to q4) . And when i dragged 7.16 downwards, it only gave me the q1 numbers.
It only worked when i entered an if statement for each row independently.
@@lebanesedashcam553 i guess u using excel 2013 version too?
So what i did is just i make an absolute reference to the logical_test then drag to the right til Q4. So for other row just do the same but make sure u absolute reference to correct cell.
@@goms2939 I didn't it your way, and it worked! Thank you so much!
It works only one cell and
I have a problem now
I don't know what to do
you only need to copy the if from q1formula to the rest q cell by sell than you can drag them down, hope it helps
simply encode the first column and drag it