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 / August 2006

Tip: Looking for answers? Try searching our database.

Make Bar Graphs Wider

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tony - 24 Aug 2006 22:37 GMT
I have a PPT slide that I import from excel. The labels for the bars are 7/1,
7/8, 7/15 ETC.(Weekly). The bars are very thin and gaps between the bars very
wide. How do I make the bars wider and the gap narrower from within
powerpoint.

Thanks in advance
Echo S - 24 Aug 2006 23:13 GMT
Double-click to open the graph. It will open in an Excel window.

Right-click a data series and choose Format Data Series. Go to the Options
tab. Adjust overlap and gap.

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

>I have a PPT slide that I import from excel. The labels for the bars are
>7/1,
[quoted text clipped - 4 lines]
>
> Thanks in advance
Andy Pope - 24 Aug 2006 23:31 GMT
Hi Tony & Echo,

This sounds more like the axis is being treated as Time series rather
than Categorys due to the date labels.

Right click the chart and pick  Chart Options. On the axis tab set the x
axis to Category rather than Automatic.

Cheers
Andy

> Double-click to open the graph. It will open in an Excel window.
>
> Right-click a data series and choose Format Data Series. Go to the Options
> tab. Adjust overlap and gap.

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Tony - 25 Aug 2006 11:39 GMT
Thanks Andy,

I think this is exactly what I wanted, it worked.

> Hi Tony & Echo,
>
[quoted text clipped - 11 lines]
> > Right-click a data series and choose Format Data Series. Go to the Options
> > tab. Adjust overlap and gap.
Echo S - 25 Aug 2006 15:18 GMT
Ah, great! It didn't occur to me that you didn't want the time series. (So
glad there are Excel guys who read here, too.)

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

> Thanks Andy,
>
> I think this is exactly what I wanted, it worked.
 
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.