Hi all, my first post here. The title is misleading as my question is a bit more complex that it suggests. My company has many offices with widely varying rent amounts and lease durations. What I'd like to do is create a bar graph with the rent amount on the X axis and the lease duration, in months, on the Y axis, but with the bar itself varying in width dependent on the rent amount.
In other words, if Office A's rent is twice as much as Office B's rent, the bar representing office A should be twice as wide on the X axis. The height of each bar represents how many months are left in the lease, and therefore the bar height is completely independent of the bar width. Is this doable? Such a graph would quickly allow the viewer to know which offices cost the most and what the rent commitments would be for the next few years.
I came across this video and got excited until I realized this was only half the solution:
https://www.youtube.com/watch?v=FmdJi4XswXA
It explains how to do variable width bars, but not how to have variable heights. In other words, this video show how to mak ethe bar widths be in the same relative proportions as their heights. That's not what I'm asking for.
PS. I am not a coder, though I did do a little VB several years ago. I'm primarily interested in a solution that does not require VBA, if it exists.
In other words, if Office A's rent is twice as much as Office B's rent, the bar representing office A should be twice as wide on the X axis. The height of each bar represents how many months are left in the lease, and therefore the bar height is completely independent of the bar width. Is this doable? Such a graph would quickly allow the viewer to know which offices cost the most and what the rent commitments would be for the next few years.
I came across this video and got excited until I realized this was only half the solution:
https://www.youtube.com/watch?v=FmdJi4XswXA
It explains how to do variable width bars, but not how to have variable heights. In other words, this video show how to mak ethe bar widths be in the same relative proportions as their heights. That's not what I'm asking for.
PS. I am not a coder, though I did do a little VB several years ago. I'm primarily interested in a solution that does not require VBA, if it exists.
