View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
MikeR-Oz MikeR-Oz is offline
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