So I made a macro that colors certain shapes (terratories in the U.S.- poor man's GIS) based on numbers in cells. It works great, except that I'm forced to choose from the old, unappealing Excel 2003 colors. Is it possible to select the nice excel 2007 colors instead?
I have a dashboard that has a scroll bar on it and I copied this dashboard in order to make a similar one that uses different data. In the copied dashboard there is a small sliver of the scroll bar from the original dashboard that I cannot move or delete and it is driving me nuts. Has this...
Hello, I'm working on a dashboard that includes some charts that are changed via drop-down lists. That's simple enough, but the problem is the chart axis and the automatic scaling. There isn't a good fixed minimum that I can set the axis to, so I will need a macro to change the scale based on...
Hello, I've been working on a dashboard that has a few drop-downs, option buttons and scroll bars. I would like to protect the sheet so that the users don't mess with it, but once the sheet is protected, it won't allow you to select the dropdown options. Any suggestions?
I have a list of buildings and their energy usage trend. the list looks like this:
building % variance
xyz 12%
xzy -10%
yyz 30%
I need a formula that will pick out the buildings that have met a certain condition. So for example if I want to pick up all...
I am trying to create a dashboard that includes a bubble chart, but the data I am representing is in the size of the bubble, not the X,Y position. I would like to represent the other data via a color scale. aka a green bubble would have a better value than a red bubble. Is there any way to do...
So I'm creating a ranking index which uses a basic min/max formula to give a certain category a ranking out of 100. Each category is then weighted between 0 and 1 and the sum of the indicies multiplied by the weights then gives me my final index ranking.
So, I'm wondering if there's a way to...
I know there are literally dozens of pages about doing a countif with two conditions, but none of them work for me. I'm using excel 2003, so I can't us countifs. I need to count how many times the phrase "Total Operational" appears with a "0" in a column to the right of. I've tried the...
I work for an agency that manages buildings, and I have a nice looking distribution scatter-plot of the all of the building's energy performances. What I would like to do is add a field where you can enter the name of the building and then press a button and excel will highlight the building on...