The purpose of the chart is to show how low the vacancy rate is, so it is important to reflect the comparison on one chart. Is the stacked column chart the best chart to demonstrate this? Thanks.
I've spent the better part of two days... today I tried to adapt a bullet chart for my purpose but I am having problems getting what I want to show. I am trying to develop a chart that shows total vacant space on floors in one color (or the degrees in a thermometer chart); vacant space per floor...
This is really frustrating me.
I thought this formula would be easy but for some reason, the conditional format is not working.
I have a range of cells (A1, B3)
The formula in B1 is a simple "if-then" such that if there is no text found, the result is ""
ACTUAL FORMULA IS...
I have 2 worksheets (in two different workbooks):
First worksheet, 1st column has department abbreviations, 2nd column
has the formal department names
Second worksheet, 1st column has abreviations, 2nd column contains
department nicknames, 3rd column contains floor space by the floor
for...