A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do I add times to the scale in a bar graph?



 
 
Thread Tools Display Modes
  #1  
Old March 22nd, 2006, 05:59 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default How do I add times to the scale in a bar graph?

I need to create a bar graph using 4 teams, Mon-Fri, and then the work times.
Can anyone advise how to set up times on the left hand scale?
Thank you for any assistance you can provide.
  #2  
Old March 22nd, 2006, 10:37 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default How do I add times to the scale in a bar graph?

Add more rows (or columns) to the datasheet? Change the axis scale or the
tick mark interval? I think you'll have to give a better description of what
you're talking about.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Confused" wrote in message
...
I need to create a bar graph using 4 teams, Mon-Fri, and then the work

times.
Can anyone advise how to set up times on the left hand scale?
Thank you for any assistance you can provide.


  #3  
Old March 23rd, 2006, 02:26 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default How do I add times to the scale in a bar graph?

I need to graph start and finish times (ie. 1000am - 10pm). So the bars would
be my teams, the bottom axis would be mon-fri. How do I change the axis on
the left to show times. Is this even possible?

"Suzanne S. Barnhill" wrote:

Add more rows (or columns) to the datasheet? Change the axis scale or the
tick mark interval? I think you'll have to give a better description of what
you're talking about.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Confused" wrote in message
...
I need to create a bar graph using 4 teams, Mon-Fri, and then the work

times.
Can anyone advise how to set up times on the left hand scale?
Thank you for any assistance you can provide.



  #4  
Old March 23rd, 2006, 09:06 PM posted to microsoft.public.word.tables
external usenet poster
 
Posts: n/a
Default How do I add times to the scale in a bar graph?

I can't give you all the details since I've never attempted this, but it
appears that a good place to start would be Chart | Chart Type | Custom
Types: Floating bars. To tell you the truth, though, I think I'd use a table
for this instead, merging cells as needed. That is, create a table with six
columns (or ten if you want spacer columns between the days) and as many
rows as you need shifts or hour divisions or whatever (if the shifts are the
same every day, you might just have a single row for each shift). The
leftmost column would indicate the times. Then use color fill or text to
indicate the teams.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Confused" wrote in message
...
I need to graph start and finish times (ie. 1000am - 10pm). So the bars

would
be my teams, the bottom axis would be mon-fri. How do I change the axis on
the left to show times. Is this even possible?

"Suzanne S. Barnhill" wrote:

Add more rows (or columns) to the datasheet? Change the axis scale or

the
tick mark interval? I think you'll have to give a better description of

what
you're talking about.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the

newsgroup so
all may benefit.

"Confused" wrote in message
...
I need to create a bar graph using 4 teams, Mon-Fri, and then the work

times.
Can anyone advise how to set up times on the left hand scale?
Thank you for any assistance you can provide.




 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Make graph paper in word or excel to scale .125" by .125"? Kris@Cooper Using Forms 1 March 9th, 2006 05:57 PM
Problem with a bar graph plotting in Access 97 s3computers Setting Up & Running Reports 1 February 24th, 2005 04:24 PM
How To Modify One Point In A Graph... Pierre Charts and Charting 3 November 25th, 2004 10:08 AM
Graph and Charts Kart18 General Discussion 0 October 19th, 2004 04:39 PM
Scaling on Scatter Graph Vince Charts and Charting 2 July 21st, 2004 09:00 PM


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.