Search results

Thanks SirJB7! You're awesome! greykitten

Hi, I'm struggling with a dynamic range graph formula. I can get it to work when the data is aligned vertically. But when I try to change the offset formula so that it reads the most recent 12 values horizontally, the formula returns an error message. It's a small problem in the formula...

Hello, I was practicing creating a multiples chart using the directions from a Chandoo post. The directions instruct the user to create an area chart and then to add the same data twice using paste special in order to create data points. I am on Excel 2010 and I tried quite a few times...

Hello, My boss wants to see 3 stacked bars (with two metrics on each) for each month. I've played with the stacked bar chart and I've only been able to show all 6 metrics on one single bar. Is there some creative way to have three stacked bars for each month on a graph?? Please see example...

Dear SirJB7, Thank you so much! That worked great. If I had a larger list of items, say 100, how would I write it so that only items ranked 1-10 would appear? Rank<10? Last thing, is there a way to arrange the text items in descending order by their respective rank value?? Thanks...

Hi, I need to use the IF formula to return the name of a cell that has a certain rank. I have ten cells with text words in them and each has a rank 1-10. And I need the names to populate in a column in order of rank. I can't figure out how to write this in the syntax. I've uploaded the file...

Hi, Regarding the shading chart showing returns above/below average, the data I need to show is fraud losses in comparison to industry average. So I need to show the above and below in reverse. Below industry average needs to display as good (green and needs to show the difference underneath...

Anyone have a more informative expansive answer? Thank you, greykitten

Hi, A tutorial on how to highlight the best month in a trend chart was recently sent and I have some questions on how I would apply this to my work. For my type of analysis, the lowest monthly values are the ones I would need to highlight in the chart. Looking at the downloaded example...

Hello, Thank you so much to everyone who replied! I greatly appreciate your help. I searched throughout the forum and the search engine for hours but was unable to find any help on this. To NARAYANK991, may I ask how you defined the "=Curr_Mnth" formula? I saw nothing like this in the...

I need an Excel function that will calculate a moving average on monthly data for time periods of 3,6,12 & 36 months. The average for each of these time periods must not include the current month's data. It must only include the prior 3,6,12 & 36 month data. I've been struggling with the...