PC Review


Reply
Thread Tools Rate Thread

Can I change a bar graph to start mid-graph?

 
 
ADPeterson
Guest
Posts: n/a
 
      22nd Oct 2008
I am trying to create a bar graph that shows different tasks that will start
in different months and whose durantions will vary. I want my graph to show
the start and end months of each activity as they are scattered throughout
the graph. Does anyone know how to accomplish this?
 
Reply With Quote
 
 
 
 
Lucy Thomson
Guest
Posts: n/a
 
      22nd Oct 2008
Like a gantt chart? You would need to make it in excel then copy/paste in to
powerpoint:
http://office.microsoft.com/en-us/ex...346051033.aspx

More detailed info here:
http://peltiertech.com/Excel/Charts/GanttLinks.html

Lucy

--
Lucy Thomson
PowerPoint MVP
MOS Master Instructor
www.aneasiertomorrow.com.au

Come say hello at Office DevCon in Sydney
www.officedevcon.com.au



"ADPeterson" <(E-Mail Removed)> wrote in message
news74AF801-7B5F-4EB1-A060-(E-Mail Removed)...
>I am trying to create a bar graph that shows different tasks that will
>start
> in different months and whose durantions will vary. I want my graph to
> show
> the start and end months of each activity as they are scattered throughout
> the graph. Does anyone know how to accomplish this?



 
Reply With Quote
 
Andy Pope
Guest
Posts: n/a
 
      23rd Oct 2008
Hi,

Floating bars can be made using 2 data series plotted as stacked bar.
The first series being formatted to have no border or fill.
Lucy has given you links to site explaining this trick.

You can do this chart type in MSGraph, if you have to
This small table (3x5) plotted by column will give you the floating bars.


Start Duration
a 04/08/2008 33
b 21/08/2008 15
c 18/09/2008 15
d 01/09/2008 6

Cheers
Andy

ADPeterson wrote:
> I am trying to create a bar graph that shows different tasks that will start
> in different months and whose durantions will vary. I want my graph to show
> the start and end months of each activity as they are scattered throughout
> the graph. Does anyone know how to accomplish this?


--

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

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
display dots inside a cell in graph form but without Excel graph? Rich Microsoft Excel Programming 8 25th Nov 2009 05:21 AM
Hyperlinkage of one graph with another graph or Drill down graph =?Utf-8?B?U2FuamF5IEt1bWFyIFNpbmdo?= Microsoft Excel Charting 1 3rd Jan 2006 12:22 PM
My Graph in access keeps on showing North Wind graph and not data. =?Utf-8?B?ZHVkbGV5?= Microsoft Access Database Table Design 0 28th Sep 2004 03:03 AM
Graph Feature is reinstalled each time I open graph on existing database Louis Microsoft Access Getting Started 0 16th Oct 2003 06:17 PM
Graph Feature is reinstalled each time I open graph on existing database Louis Microsoft Access Form Coding 0 16th Oct 2003 06:17 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:29 PM.