Chart Layout help

[droo09]

So I am trying to create a chart to have a certain layout but have been unsuccessful. I need to have each bar to be labled with the date, but underneath it the date labels, is it possible to have a single label that encompasses all those date? So effectively it would be a sub label. Also keep in mind that since this is going to be a dynamic graph, I cant simply label it. Below is what I want the labeling to look like. Thanks!
___
| |
| | ---> graph goes on..
| |
Jan-1 Jan-2 Jan-3 Jan-4 Jan-5 Jan-6 Jan-1 Jan-2 Jan-3 ect...

ACCOUNT NAME#1 ACCOUNT NAME#2


Also, is there a way for graph to resize itself automatically as needed? Some of these accounts span for years, and some a few months, so it will be pain for my boss to have to resize graphs every time.

 

[Steve=True]

Part 1:I think you can do this if you chart the company names in an addiional column that will group the dates by company:
See this: http://chandoo.org/wp/2010/11/17/show-months-years-in-charts/


Part 2: to make your charts dynamic you will need to use a formula like offset to get the set of data for this company:
See this: http://chandoo.org/wp/2009/10/15/dynamic-chart-data-series/

Good luck, hope this helps!