Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 46
Default bar graphs that are have bars joined together



"BoniM" wrote:
Thats fantastic. I am always in awe of the skills and willingness of others
to help. Cheers
Mike
http://www.maysstuff.com/offdocs/ChartSample.xls
This might be more like what you wanted...

"MikeR-Oz" wrote:

Thanks my friend. I had tried it but did not seem to work.

I have placed the file on this link
http://www.freefilehosting.net/download/3h7ij if you wish to see what it is
all about.

Mike

"BoniM" wrote:

I think this might be what you're looking for.
Right click on the data series and choose Format data series...
Under options, change the Gap width to zero.

"MikeR-Oz" wrote:

I just cannot seem to get this to happen. Instead of a space between each
piece of data I want the bar to look more solid in connection.

I have hours in 15 minute incements over a 24 hour period eg.A2:10, and say
the date in B1.

In each B2 down to B10 there may be counts 1 in B2, 1 in B3, 3 in B4, 2 in
B5 as the 15 minutes tick by.


I would then have say counts of how many occassions along the 15 minute
increments I had crews active in a graphical manner not unlike the 'area'
type graph BUT square

Cheers
Mike

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I do individual error bars for bar graphs? Slyther Charts and Charting in Excel 1 May 4th 07 08:29 AM
Reordering Bars in Bar Graphs [email protected] Charts and Charting in Excel 0 July 18th 06 05:58 PM
How do I get custom y-error bars in Excel graphs (using Office 200 Michael_amon Excel Discussion (Misc queries) 0 July 13th 06 06:01 AM
How do I specify using lines or bars on graphs w/ 2nd value axis? Motorhead Charts and Charting in Excel 1 June 22nd 05 08:41 PM
How do I plot error bars on 3D graphs? jho105 Charts and Charting in Excel 1 May 5th 05 09:36 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"