Breaking a Bar Chart

[Legacy 96659]

Ok I'm pretty hopeless with Graphs but nobody else here can create them on Excel!

Using my trusty GCSE Excel knowledge I've managed to create a bar chart to show leases of some properties with e the Building name as a legend and the lease end year as the length of the bar (all bars start in 2008)

All colours legends places etc are ok, problem comes when someone asks for a break date to be added

Basically a tenant can end a lease early on certain dates if they pay a penalty rent (usually 1 year's worth).

I need to find a way of shoing these dates on the bars by breaking up the bar half a year before the date and restartiing half a year after..

I am in no way skilled enough to do that and pens are not allowed!

Eg. X Ltd rents Property A till 2050 but may call off the lease in 2025

Years .......08 09 10.... 25....... 50

Property A |__________| |_____| 2050

======================================//==========================================

Even a line down the middle of the bar at the appropriate year would be good but atm I'm telling them it can't be done!

Any help appreciated

Dan Armstrong
Garner Associates

 

[Andrew Poulsom]

You need a stacked bar chart (the subtype at top middle) plotting 2025 as series 1 and 25 (making the total 2050) as series 2.

 

[Legacy 96659]

Stacked is good for showing for 1 property it seems, but what do you do if you have (say) 10 properties each with a break date?

*experiments with stacked bars but ends up with all one the same bar*

 

[Andrew Poulsom]

I had no trouble plotting this data in A1:C3:

            Val1    Val2
Property1   2025      25
Property2   2020      35

Series 1 B2:B3
Series 2 C2:C3
Category (x) axis labels A2:A3