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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |