Variable bar chart column width depending on value

[revershed]

Wondering if anyone can help, not being familiar this is probably an easy one for someone with Excel ninja skills:

Along the x axis = time; y axis = ticket cluster ID

Each ticket cluster ID has a life span (date range) which is shown in x-axis and within each ticket cluster ID is a number of individual tickets.

Would like the width of the bar to vary depending how many tickets (bar width) are within the ticket cluster but this also needs to have a start and end date (bar length)

For example:

Ticket cluster ID = 3456
Tickets = 30
Start/end = 02/05/2012 06/06/2012


Ticket Cluster ID = 1234
Tickets = 45
Start/end = 01/06/2012 15/06/2012

Any questions/further info give me a shout

 

[VoG]

This might help AJP Excel Information - Variable width columns