Brent asked me how I managed to draw a curved arrow on a worksheet. Episode 1164 takes a look at how to customize the drawing tools to draw in curved arrows.
Transcript of the video:
The MrExcel podcast is brought to you by “Easy-XL”!
Hey, welcome back to the MrExcel netcast, I’m Bil Jelen.
Yesterday we're talking on something really complicated, OFFSET, and today's question comes from Brent, it just amazes you what can impress someone.
Brent said “How'd you get that curved arrow on my spreadsheet?” I’m like What?” “Yeah, the curved arrow.
Every time I try and draw a line, it just comes in straight.” And so, let's just take a quick look at this, I mean it's the holiday week, what the heck.
Insert, you know, so we have shapes here, and we have arrows, you know, but the problem of this arrow is it always goes straight.
And so what I'm going to do is, that Insert tab really has a lot more than just the shapes that are listed here, I’m going to come down here to something called the Curve.
Alright, and the way the curve works is, I start to draw from here, and basically every time that I click, I define kind of a, maybe a turning point along the curve, so I can create some nice little drawing here.
Now, the problem with the curve, of course, is that there are no arrows on it, but that's okay, when we're done with the curve, double-click, and we draw the curve in.
Now here, watch what we can do, we can come in to Shape Outline, Arrows, and add a closing arrow, that way we kind of specify a direction.
We can also do Shape Outline, Weight, make it a bit thicker, and of course, easy enough, to change the color of the arrow.
Alright, and then this is pretty wild, you wouldn't think that this’ll be built into Excel.
I'm going to right-click on the line, and there's something here called Edit Points, edit points actually shows me all the places where I clicked while I was creating that line.
So I can actually come in and edit all of those click points, if I would need to move things around, you know, kind of, I don't know.
It's strange, you know, we have Excel, it's numbers, it's formulas, it’s INDEX, it's OFFSET, it’s VLOOKUP, but it's, you know, there's some component here.
You know, the drawing tools team, who really kind of gave us some interesting options as far as drawing curved lines, and the whole edit points, you know, I had never really even seen that.
So I started to think about Brent's question of “Well, how DID I get that curved arrow in there?” and lots of functionality.
There you go, we go from OFFSET yesterday, something to make your head spin, to something very light and easy, adding a curved arrow.
Next time you need to draw a line from here to here, but not touch that data there.
Why hey, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
Hey, welcome back to the MrExcel netcast, I’m Bil Jelen.
Yesterday we're talking on something really complicated, OFFSET, and today's question comes from Brent, it just amazes you what can impress someone.
Brent said “How'd you get that curved arrow on my spreadsheet?” I’m like What?” “Yeah, the curved arrow.
Every time I try and draw a line, it just comes in straight.” And so, let's just take a quick look at this, I mean it's the holiday week, what the heck.
Insert, you know, so we have shapes here, and we have arrows, you know, but the problem of this arrow is it always goes straight.
And so what I'm going to do is, that Insert tab really has a lot more than just the shapes that are listed here, I’m going to come down here to something called the Curve.
Alright, and the way the curve works is, I start to draw from here, and basically every time that I click, I define kind of a, maybe a turning point along the curve, so I can create some nice little drawing here.
Now, the problem with the curve, of course, is that there are no arrows on it, but that's okay, when we're done with the curve, double-click, and we draw the curve in.
Now here, watch what we can do, we can come in to Shape Outline, Arrows, and add a closing arrow, that way we kind of specify a direction.
We can also do Shape Outline, Weight, make it a bit thicker, and of course, easy enough, to change the color of the arrow.
Alright, and then this is pretty wild, you wouldn't think that this’ll be built into Excel.
I'm going to right-click on the line, and there's something here called Edit Points, edit points actually shows me all the places where I clicked while I was creating that line.
So I can actually come in and edit all of those click points, if I would need to move things around, you know, kind of, I don't know.
It's strange, you know, we have Excel, it's numbers, it's formulas, it’s INDEX, it's OFFSET, it’s VLOOKUP, but it's, you know, there's some component here.
You know, the drawing tools team, who really kind of gave us some interesting options as far as drawing curved lines, and the whole edit points, you know, I had never really even seen that.
So I started to think about Brent's question of “Well, how DID I get that curved arrow in there?” and lots of functionality.
There you go, we go from OFFSET yesterday, something to make your head spin, to something very light and easy, adding a curved arrow.
Next time you need to draw a line from here to here, but not touch that data there.
Why hey, I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
