Make Vertical Bars - Make Progress Bars with Sparkline: Part 3

<div> Hi. So in the first two videos, we created a progress bar Learn how to create and customize progress bars in your sheets. Opens in new tab . Then we hid those bars when they were actually completed. Right now we're gonna go through what does it take to make a vertical progress bar Learn how to create and customize progress bars in your sheets. Opens in new tab . What happens is that sparkline Discover how sparklines can visualize data trends in a compact format. Opens in new tab doesn't transpose and you can't turn it sideways, so you can't use the exact same formula Understand the syntax rules for writing formulas in your sheets. Opens in new tab .<br><br>What you can do, let me move my face. What you can do is use this chart type Explore different chart types available for visualizing your data. Opens in new tab column. So spark line has this other chart type Explore different chart types available for visualizing your data. Opens in new tab we've been using bar, but if you use column and you put in 55, there's no maximum, right?

So what you get is just this, you can change this number Get insights on how to format and manipulate numbers in your sheets. Opens in new tab to anything and it doesn't change.<br><br>So what you need to do and I did it in this one is give a y minimum and a y maximum. Set those two values Learn about the importance of values in your spreadsheet calculations. Opens in new tab in the options. And you'll get a vertical progress bar Learn how to create and customize progress bars in your sheets. Opens in new tab . That's it. And you can also change the color as well. You can. Make this why min and why maximum formula Understand the syntax rules for writing formulas in your sheets. Opens in new tab if you wish. You can do a lot of different things to fit the same things you can do with the progress bar Learn how to create and customize progress bars in your sheets. Opens in new tab .<br><br>Sorry that we did hear the type, the bar chart Find out how to create and customize bar charts for data representation. Opens in new tab type.

I'm gonna show you though one more way to do a progress bar Learn how to create and customize progress bars in your sheets. Opens in new tab vertically. And this is not to say that either of these ways are better. This one takes one. Row, and it takes the size of the row. So if I actually increase the size of this row right now, it, it takes the minimum maximum of this row.<br><br>That might not be ideal for a variety of reasons. You. , you might want to take up multiple rows. So what I do here, and I've done this a couple times, is you have some number Get insights on how to format and manipulate numbers in your sheets. Opens in new tab that you're gonna change, right? 30. You wanna change that to 45.

And this is just me changing this automatically and you see this vertical chart Dive into the world of charts and how they can enhance your data analysis. Opens in new tab showing up.<br><br>And then if we get into a hundred and this takes exactly 10.&nbsp; Why that is here, I will show you. There's 10 rows here. Why that is, is because what I've done in each of these in each of these cell blocks, if statement, that if this number Get insights on how to format and manipulate numbers in your sheets. Opens in new tab C 79 is above 99, then market as one. So it has a value of one.<br><br>If it not, it has a value to zero. Why am I doing that? Here, I'll show you zero here. , this will be zero. What and why is it changing in the color?

What it is I went up to format Master the art of formatting to make your sheets visually appealing. Opens in new tab conditional formatting Learn how to apply conditional formatting for dynamic data visualization. Opens in new tab , and I gave these rules to all of the entire thing. So I just have to set this rules twice to set for zero if the value is equal to zero.<br><br>Let me move my face again, . If the value is equal to zero, the formatting Master the art of formatting to make your sheets visually appealing. Opens in new tab style is the text inside is white and the fill color Discover how to use fill colors to enhance the readability of your sheets. Opens in new tab is white. And then the other one, and then I put a little border around it to see the border. But let me show you the other. One Commissional formatting Master the art of formatting to make your sheets visually appealing. Opens in new tab the value is equal to one.<br><br>I set the same thing, but just green, right?

So the text color Understand how to change text colors for better data presentation. Opens in new tab is green and the fill color Discover how to use fill colors to enhance the readability of your sheets. Opens in new tab is green if it's one. So all we're doing is using this if state if formula Understand the syntax rules for writing formulas in your sheets. Opens in new tab right here. So it's like 12, it's gonna be one 10th, and it's not absolutely exact, right? It's not gonna change when it's there. If it's 19, it's not gonna change.<br><br>It's only gonna change to. This gives a really nice vertical representation of progress, if that's what the story needs and or what the chart Dive into the world of charts and how they can enhance your data analysis. Opens in new tab needs. I have put these on the side of some project to give an overall estimate of where Learn about using the WHERE clause in queries for data filtering. Opens in new tab we are in the project, and it's been very well taken.

It's really nice, you can set a single number Get insights on how to format and manipulate numbers in your sheets. Opens in new tab .<br><br>Do you know, some kind of formula Understand the syntax rules for writing formulas in your sheets. Opens in new tab here if you want to go a little bit more. But I felt this was a, it's a nice way to do a vertical bar chart Find out how to create and customize bar charts for data representation. Opens in new tab and gives you a little bit more playroom. See it, it fills the entire cell if we go back up here, this cell is not filled all away.&nbsp; Left and right.<br><br>You can set your co even though you can set colors in these bar charts, this one's cool. You can even set different colors all the way up. And it's pretty simple to execute. Just have this if function Get familiar with functions and how they can automate your calculations. Opens in new tab , if, and set each of these one or zero.

And that's it. Next up I'm gonna be showing you though, if you do wanna go back to using progress bars and you wanna change the color of them that's a really funky thing to do and it really makes you feel like things are changing as you are progressing through something.<br><br>That's gonna be in the next video.</div>