Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General PowerPoint Questions / September 2006

Tip: Looking for answers? Try searching our database.

Drawn Box Charts

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Martin - 29 Sep 2006 16:38 GMT
Hi, I am in an office setting that uses embedded Excel Charts in PowerPoint.
Recently, a contractor has joined and replaces the existing charts with drawn
charts made from boxes or a line with Edit points.
My question is, how do I learn to add this type of skill to my arsenal of
Advanced Office skills? Is this practice of drawing charts approved of by
Microsoft? I have never learned to make charts in this manner, but have run
across this situation from time to time and want to be able if the need is
required to manipulate these (as I see it) "uneditable charts"!

Thank you,
Martin Boone
Echo S - 29 Sep 2006 19:06 GMT
I often have to draw charts if the data is unavailable to me to actually
graph it. (Although right now I'm working on some really nasty ones that
would take me longer to draw than to plot, so I'm using GrabIt to generate
the data from images. My copy is very old, so I can't tell you anything
about the current one. It seems very different now, though.)

I have a little tutorial on Bezier curves / edit points that should help get
you started. http://www.echosvoice.com/beziercurves.htm But I don't know of
anything specific to redrawing *charts* specifically. I mean, if it's a
column, a rectangle (on the drawing toolbar) will do what you need. You'll
want to become familiar with the align tools (Draw|Align and Distribute)
also, as they will be important when you draw charts. You can also tear away
and drag that Align and Distribute flyout menu onto your workspace -- or
tear it away from the menu and dock it with your other toolbars -- so it's
close at hand. (Just click the mouse on the dots at the top of the flyout
menu and drag to tear it away.)

Also, press the Shift button when drawing lines to create straight
gridlines/axes. You can use your guides (Alt+F9) to place items and help
space things out, and the aforementioned Distribute functions will help
there also. Press Ctrl while dragging a guide to create more guides. (You're
limited to 8 or 9.)

Oh, and clicking Ctrl while clicking and dragging an item creates a copy of
it. Press the Shift button along with Ctrl while you drag to create a copy
and constrain it to the same horizontal or vertical space.

Wow. I might actually be able to write up a real tutorial using this stuff
as a basis -- I had no idea I used so many "tricks" when drawing charts!

Signature

Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/

> Hi, I am in an office setting that uses embedded Excel Charts in
> PowerPoint.
[quoted text clipped - 10 lines]
> Thank you,
> Martin Boone
Martin - 29 Sep 2006 19:54 GMT
Thank you Echo for the Tutorial on Toolbars and Bexier curves. Grab It is not
an option for this company in fact. So my question comes full circle.

I am well versed in the use of toolbars, I have nearly everyone available at
ALL times as it makes going through 33 pages with heavy edits and new creates
in 90 minutes possible. However, it seems that besides my lack of both
reliance and skill on habitual spacing and respacing on every page, I am
hoping to find a way to learn the 'quick' way to readjust "53%" to "74%" on
the fly. (As you know this business depends on the ability to RAPIDLY make
the visual changes.) I can cut charts in visio, ms graph, and excel like a
hot knife through hot butter, but I am floored when I see a box chart. It is
actually 'quicker' for me to start with a basic graph in the wizard than to
try (at a deadline) to 'guestimate' where the boxes will line up. And then
there is the use of boxes that given the same width and aligned, still
misprint unaligned. I have tried to attempt this before with disasterous
consquences.
I am looking to see if there is a tutorial for learning how to manipulate
(the mouse movements, if gridlines are set at .25" horiz/vert, key strokes,
etc.) Thank you for your very thorough explanation, but I need something just
a bit different.

Martin Boone

> I often have to draw charts if the data is unavailable to me to actually
> graph it. (Although right now I'm working on some really nasty ones that
[quoted text clipped - 40 lines]
> > Thank you,
> > Martin Boone
Kathy Jacobs - 29 Sep 2006 20:10 GMT
Martin,
I don't have to do hand charts very often, but when I do, there is one cheat
I use. I figure out what bar is 100% tall. I then copy that bar for each bar
in the graph. Next, right click the first bar and go to the size tab. Change
the height to your percentage. Be sure to leave "lock aspect ratio"
unchecked and click ok. Voila - perfectly percentaged bar. Repeat for each.
When all are done, align the bottom one on the bottom line, then align all
of them to that bottom.

I know you probably already know that trick, but thought I would add it just
in case.

Signature

--
Kathryn Jacobs,  Microsoft MVP  OneNote and Powerpoint
Author of Kathy Jacobs on PowerPoint - Available now from Holy Macro! Books
Get PowerPoint and OneNote information at www.onppt.com

I believe life is meant to be lived. But:
if we live without making a difference, it makes no difference that we lived

> Thank you Echo for the Tutorial on Toolbars and Bexier curves. Grab It is
> not
[quoted text clipped - 84 lines]
>> > Thank you,
>> > Martin Boone
Martin - 29 Sep 2006 21:05 GMT
"You had me at Hello!"

That works and is very intuitive, I like it. That explains a whole other
type of skill to learn, thank you.

Martin Boone

> Martin,
> I don't have to do hand charts very often, but when I do, there is one cheat
[quoted text clipped - 96 lines]
> >> > Thank you,
> >> > Martin Boone
Echo S - 29 Sep 2006 21:46 GMT
Good trick, Kathy!

(It didn't even occur to me to mention that one -- duh. I don't have to use
it very often.)

Signature

Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006  http://www.pptlive.com

> Martin,
> I don't have to do hand charts very often, but when I do, there is one
[quoted text clipped - 102 lines]
>>> > Thank you,
>>> > Martin Boone

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.