Create a target diagram in Excel, using the business diagramming tools on the Drawing Toolbar. Episode 385 shows you how.
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!
Transcript of the video:
Hey, welcome back to the MrExcel netcast, I'm Bill Jelen.
We've talked about how to create charts before, Bar charts, Column charts, Pie charts, but did you know there's a whole series of business diagrams available in Excel?
These are on the Drawing toolbar, you need to go to View, Toolbars, Drawing, and it usually appears at the bottom of your screen.
I've moved it up to the top of my screen here today, so we can see it in the netcast.
There's the button that has three round circles with three arrows going between the circles, sort of a process diagram.
If you click that icon, Excel shows you there's basically 6 different types of diagrams available.
The first one is an Org chart, and we'll talk about that one later.
But the other ones are a Process chart, a Radial chart, a Pyramid chart, Venn diagram, or a Target chart.
So let's say we choose the Target chart, click OK, Excel draws a default diagram with three levels.
“Click to add text”, so you can click over here, some sort of text, and the other 2, but there's also a Diagram toolbar that shows up.
In the Diagram toolbar, we can say that we want to Insert a Shape, so you can insert as many shapes as you want.
You can Reverse the shapes from inside to outside, and also choose different layouts, Fit Diagram, or Resize, or Expand, or use one of their AutoLayouts.
There's also an option here where we can change the color.
If you click the gallery, you'll see that there's basically five or six different colors that you can choose to create for really sharp-looking target charts.
Business diagrams are been hiding there on the drawing toolbar forever, not many people use them.
In Excel 2007, they really get promoted, there's about 75 different types of business diagrams called SmartArt!
But until Excel 2007 gets here, go ahead and explore with the Business diagrams in the Drawing toolbar of Excel 2003.
Hey, thanks for stopping by, we'll see you next time for another netcast from MrExcel!
We've talked about how to create charts before, Bar charts, Column charts, Pie charts, but did you know there's a whole series of business diagrams available in Excel?
These are on the Drawing toolbar, you need to go to View, Toolbars, Drawing, and it usually appears at the bottom of your screen.
I've moved it up to the top of my screen here today, so we can see it in the netcast.
There's the button that has three round circles with three arrows going between the circles, sort of a process diagram.
If you click that icon, Excel shows you there's basically 6 different types of diagrams available.
The first one is an Org chart, and we'll talk about that one later.
But the other ones are a Process chart, a Radial chart, a Pyramid chart, Venn diagram, or a Target chart.
So let's say we choose the Target chart, click OK, Excel draws a default diagram with three levels.
“Click to add text”, so you can click over here, some sort of text, and the other 2, but there's also a Diagram toolbar that shows up.
In the Diagram toolbar, we can say that we want to Insert a Shape, so you can insert as many shapes as you want.
You can Reverse the shapes from inside to outside, and also choose different layouts, Fit Diagram, or Resize, or Expand, or use one of their AutoLayouts.
There's also an option here where we can change the color.
If you click the gallery, you'll see that there's basically five or six different colors that you can choose to create for really sharp-looking target charts.
Business diagrams are been hiding there on the drawing toolbar forever, not many people use them.
In Excel 2007, they really get promoted, there's about 75 different types of business diagrams called SmartArt!
But until Excel 2007 gets here, go ahead and explore with the Business diagrams in the Drawing toolbar of Excel 2003.
Hey, thanks for stopping by, we'll see you next time for another netcast from MrExcel!
