Excel Shapes - How to use Excel as a drawing tool | excel drawing toolsexcel drawing tools
Editor's note: The afterward cavalcade was accounting by PowerPoint MVP Glenna Shaw as allotment of our Technical Tuesday series.
["398.67"]
Excel Drawing Toolbar | excel drawing toolsWhen PowerPoint Designer’s new timeline affection was arise I admired it. But I additionally thought, “What if you’re application a custom affair or alive an beforehand adaptation of PowerPoint?”
In this, I was aggressive to see what you could do to actualize your own timelines application PowerPoint’s and Excel’s charting tools. This commodity includes instructions for alive with date and time ethics in Excel, as able-bodied as how to actualize the custom timeline archive I came up with.
Some association may acquisition it catchy to assignment with dates and time in Excel, but it’s appealing attainable if you stick with application all dates or all times on your charts. Excel usually applies the actual formatting for you if you access the abstracts in the adapted format. For dates, blazon in MM/DD/YYYY. And for time, blazon in HH:MM AM/PM. You shouldn’t accept to anguish about formatting. If you do charge to actual formatting, use the formatting bead bottomward on the apparatus bar and accept the date or time architecture as appropriate.
This blueprint is appealing attainable to make, and you can adorned it up as abundant as you appetite with aloof a few formatting changes. It uses a band blueprint with anniversary of the items, accepting a amount of 1 so you get a nice beeline line. One of the advantages of the timeline blueprint over the Designer timeline is the proportional agreement of the dates/time. The Designer timeline will amplitude the accomplish equidistantly as against to accordant to the dates/times. Here's how to do it:
1. Insert a band blueprint with markers on your slide.
2. In the Excel window, change the abstracts to what you appetite for your timeline.
3. Replace Categories with your timeline steps, access the dates (or time) in the additional cavalcade and in the third cavalcade accord anniversary footfall a amount of
4. Abutting the Excel window.
Your blueprint should attending commodity like this:
5. From the Blueprint Accoutrement Design tab, bang Select Data.
6. Select the B and C columns for your abstracts and bang ok.
Your blueprint should now attending commodity like this:
Now you aloof charge to add abstracts labels and architecture it a bit. Set them as follows:
7. Adjust the Vertical arbor to a minimum of .5 and best of 1.5 and set the Major Unit to 1.
8. Application the Blueprint Elements Icon, uncheck aggregate except Abstracts Labels.
9. Architecture the markers to be a beyond size. If desired, change the brand to a altered shape.
["356.96"]
Excel Drawing Toolbar | excel drawing tools10. Accomplish any added formatting changes you’d like. Here's the result:
Gantt archive are advantageous back you appetite to clue assorted tasks that accept capricious timelines. Typically, these tasks will accept a alpha date and end date. The aboriginal Gantt blueprint I abstruse to do was from a tutorial by Jon Peltier application a ample bar chart. This access is abundant simpler. You can acquisition added abundant admonition for these archive in Jon Schwabish’s A Guide to Avant-garde Abstracts Decision in Excel 2016/Office365.
Gantt Table
This decision is actual attainable to do and aloof requires you to adapt your abstracts (meaning alpha dates and end dates) afore cartoon your table. This blueprint is actual able but it does accept the aforementioned limitation as the Designer timeline - anniversary of the dates arise centermost from the others. This makes it a absolute decision back your dates are of according measures, such as weeks or months, and you don’t charge to be added specific.
Gantt Band Chart
This blueprint capitalizes on the blueprint of the Gantt table but addresses the affair of centermost agreement amid dates. It uses a band blueprint with incremental ethics for anniversary assignment to abode them one aloft the other. This blueprint is added able back you charge abundant dates and they are not of according measures.
1. Insert a band blueprint with markers on your slide.
2. Access your dates and tasks as declared for the Gantt table.
3. Add numbers in the beef beneath the alpha date and end date for anniversary task. Increment the cardinal for anniversary row by 1.
4. Stretch the blueprint table alternative box to awning all your data.
5. Abutting the Excel window. Your blueprint should attending commodity like this:
6. From the Blueprint Accoutrement Design tab, bang Edit Data.
7. Bang the Switch Row/Column button and bang ok.
8. Abutting the Excel window.
9. Architecture the vertical arbor to appearance the ethics in reverse.
10. Application the Blueprint Elements icon, uncheck aggregate except the primary accumbent arbor and abstracts labels.
["582"]
Excel Drawing Toolbar | excel drawing tools11. Set the abstracts labels to Alternation name and Characterization Position Left
12. Bang alert on the additional abstracts characterization of anniversary assignment and annul the abstracts label.
12. Architecture as desired. Here's the result:
This abutting blueprint is bit unusual. It uses a pie blueprint to affectation the timeline as beheld chunks of a day or an hour. It’s a abundant decision if you are giving a presentation that has an calendar burst into chunks of time over a day or an hour, such as training or a meeting. The slices on the day blueprint will adjust with the area of the hour duke of a alarm and the slices of the hour blueprint will adjust with the minute hand. These archive acquiesce the admirers to calmly see how the day/hour is disconnected up.
Daily Agenda
The circadian calendar blueprint starts at 6 AM and ends at 6 PM to use the abounding 360° of the pie chart. The aboriginal row of abstracts accounts for the time from 6 AM until your calendar starts and the aftermost row accounts for the time your calendar ends until 6 PM. The blueprint is rotated by 180° to acclimatize the slices properly.
1. Insert a collapsed pie blueprint on your slide.
2. In the Excel window, bang the Edit Abstracts in Microsoft Excel icon.
3. Enter your Calendar Topics, Alpha times, and End times as shown:
4. Abutting the Excel window.
5. From the Blueprint Accoutrement Design tab, bang Select Data.
6. Uncheck the Alpha time and End Time Alternation and change the Accumbent arbor labels to the Alpha Time column.
7. Your blueprint should attending commodity like this.
Now you aloof charge to circle the chart, add abstracts labels and architecture it a bit.
8. Bang on the pie blueprint and adapted click, Architecture Abstracts Series.
9. Change the bend of aboriginal allotment to 180°
["1241.6"]
Using Drawing Tools in Excel 2007, 2010 and 2013 - YouTube | excel drawing tools10. Add abstracts labels and set them as follows:
11. Using the Blueprint Elements Icon, uncheck aggregate except Abstracts Labels.
12. Annul the abstracts labels for Aboriginal Row and Aftermost Row and recolor those slices to be the aforementioned color.
13. Use shapes to actualize alarm easily on top of the chart.
14. Apply added formatting as desired. Here's the result:
Here's the Alternate Circadian Calendar Chart:
Hourly Agenda
The alternate calendar blueprint starts at the top of the hour and ends at the abutting of the hour. It automatically uses the abounding 360° of the pie blueprint as continued as you annual for the abounding 60 account of the hour. The hour blueprint does not crave rotation.
3. Repeat accomplish 4 – 7 for the Circadian Calendar Chart.
4. Repeat accomplish 9 – 11 for the Circadian Calendar Chart.
5. Repeat accomplish 12 – 14 for the Circadian Calendar Chart. Here's what it looks like:
This commodity has provided you with three new options for visualizing time in your presentations:
I achievement you acquisition them attainable and fun to use.
You can download the TimlineClocksCharts.pptx book from my OneDrive Visualology folder. All my added samples, templates, and assets are additionally attainable for download.
Note: you charge download the book to appearance it appropriately in PowerPoint 2016.
For added than two decades Glenna Shaw has been creating abstracts visualizations in the anatomy of presentations, activity administration tools, dashboards, demos, prototypes and arrangement user interfaces. She is a Certified Activity Administration Professional (PMP) and an alive affiliate of the PowerPoint Community. Glenna specializes in creating Microsoft Office files that are absolutely attainable to bodies application advantageous technology.
Glenna has been a spotlight apostle at events, a accountable amount able (SME) and author/technical editor for books and training courses. She frequently teaches avant-garde PowerPoint, Excel, and Word classes. Glenna is additionally the columnist of tutorials on application acoustic attitude with presentations on her glennashaw.com site.
["564.54"]
Tom's Tutorials For Excel: Linking a Drawing Object to a Cell ... | excel drawing toolsGlenna has served on the lath of admiral for the Presentation Guild™ back 2015. She is the administrator for the board that is ambience standards and implementing certifications for the presentation industry.
Glenna holds certificates in Cloud Computing, Attainable Information Technology, Graphic Design, Information Design, Knowledge Administration and Professional Technical Writing.
["600.43"]
How To Get Drawing Toolbar In Excel ~ Microsoft Office Support | excel drawing tools["495.67"]
Expert Excel Help - Adding Shapes | excel drawing tools["562.6"]
How To Make A Flowchart In Excel | excel drawing tools["643.11"]
Free and Easy to Use Tools for Drawing Mathematical Functions | excel drawing tools["388"]
How to Enable Freehand Electronic Signatures in Excel ... | excel drawing tools["388.97"]
Self Education - Learn free Excel 2013 for beginners: Drawing ... | excel drawing tools["744.96"]
Excel Shapes - How to use Excel as a drawing tool | excel drawing tools