Відео

You are welcome! Thank you for your nice comment. - Catherine

Thank you! I'm glad it was helpful. - Catherine

Thank you so much. I am glad it was helpful. - Catherine

That's great to hear. Thanks! - Catherine

Thanks for such a nice comment! 🙂- Catherine

That’s a good question. I don’t see a way to set a minimum (or maximum) value for the y axis. When I can’t format a chart the way I want, sometimes I will create the chart in Excel and then paste an image of it into Canva. I realize that's not a perfect solution - sorry not to have a better answer! - Catherine

That's great to hear! - Catherine

Yes, in that case you can add another column next to "At or Above 65" with a new condition that you define. Now you have three conditional values, make sure to make them mutually exclusieve. Exactly one condition must be true, the others must be NA(). You can repeat this process as many times as you want.

Thanks for your question. There is a good answer above from @Gapiedaan. Also, I created a new video that demonstrates how to do this: ua-cam.com/video/4JCjZLLzBXI/v-deo.html (How to create a Bar Chart with Color Ranges based on Numeric Value in Excel) - and it has in the description an Excel file you can download to see the formulas and chart. I hope this helps! - Catherine

@@Gapiedaan Thanks for providing this clear and well-written answer! 🙂 - Catherine

Great! Thank you for your nice comment. - Catherine

That's great to hear, thank you! - Catherine

That's great to hear! Thank you - Catherine

You're welcome! I am glad it was helpful - Catherine

Thank you! - Catherine

I am glad this was helpful! - Catherine

Great! Good luck with your PPT presentation! - Catherine

Great! I am glad it was helpful. - Catherine

I am glad it was helpful! - Catherine

That's great to hear - thank you! - Catherine

LOL! Great, I am glad it was helpful! - Catherine

I am glad this was helpful! 🙂 - Catherine

Thanks for your comment! I cannot find a way to display the legend vertically, listed from top to bottom. You could create the legend manually with boxes and text, but that is not an ideal solution. I will send Canva a suggestion to add this feature. Thanks again - Catherine

Thanks! - Catherine

Thank you so much! - Catherine

I will admit, charts can sometimes be challenging. But overall I really enjoy working with Excel. Thanks for watching the video and taking time to comment! - Catherine

That's great to hear. Thank you! - Catherine

Hi. This is a good question. I can not find a way to add texture (or patterns) to the bars on a chart in Canva, only solid colors. Your best choice is probably to create the chart in another app, like Excel, which allows texture on the bars. Then copy the Excel chart into Canva as an image. Sorry to not have a better answer! - Catherine

Thank you! That's great that you are creating a dashboard in Excel. - Catherine

If I understand your question, how would the chart look if the number of park visitors in July and August are the same, meaning the Aviary opening (or closing) in August did NOT change the number of visitors? In this case, you could circle the data points for both July and August to emphasize this. In the first example, make the title for the New aviary something like “New Aviary Fails to Attract More Visitors” …. and for the second example, make the title for the Closed aviary “Aviary Closed but Park Still Popular”. Please let me know if this doesn’t answer your question. Thanks! - Catherine

I'm glad this was helpful! - Catherine

Thank you for your very nice comment! - Catherine

I'm glad it was helpful! - Catherine

I am so glad to hear that. Thank you! - Catherine

Thank you for your kind comment! 🙂- Catherine

Thank you! - Catherine

LOL. If you mean showing the percentage complete and data bars in two separate columns, I included that option at the end of the video just in case it is needed. It probably doesn’t make sense when the value is percentage complete, but you never know when a client may request it that way. I do agree with you, it usually makes more sense to show the values in the same cells as the data bars. - Catherine

Thank you! - Catherine

Thank you for watching the video! - Catherine

Thank you! I am trying to produce videos more often, so I appreciate your encouragement! - Catherine

Great! I am really glad it was helpful. - Catherine

Thanks! - Catherine

Thank you for your kind comment! - Catherine

I'm glad it was helpful! - Catherine

For some reason, the Progress Ring (example 3 in the video) does not come with built-in animation like the Donut Chart. You could add the "wipe" animation setting, but it's not as cool as the Donut where it looks like a circle is drawn on the screen. I hope this answers your question, if I misunderstood, please let me know. Thanks! - Catherine

Great! I'm glad it helped. - Catherine