Search results

Luke you are the man!!!!I for one appreciate your help IMMENSELY!!!

Ugh...I forgot to meniton that it's a stacked column :-s... I'm going to try these options anyway...

Hi there- Have months 1/1-12/1 on my X axis. However, I have 1 data point of 8/16 that I also need to show on the chart. As such, there are 13 data points. When introducing the 8/16 to the chart, it messes up the axis and puts it to days. What I'd prefer is to have all months, and then 8/16...

The best! Thanks!!!

Luke- You did a similar formula for me a while back, and, I'm wondering if you can walk through the logic of he 2nd half of the IF statment: SMALL(IF($B$2:$B$10=$D$2,ROW($B$2:$B$10)),ROW(A$1)))) From what I can gather, it says take the smallest value in column B if a value from B2:B10= D2...

Hi there- I was practicing Chandoo's circular reference/in-cell chart function lesson whereby you change the iterative calculations & whatnot. Ever since doing that, my Excel has been significantly slower, and, I am now getting this message in the lower right hand corner of Excel showing my...

YESSS!!!!! Thanks PrasaddN!!!!!!

Hi there I have a project number with multiple lines that has different people at each line. What I'm trying to so is assign a number to each person (i.e. 1, 2, 3, etc). Here's how the data looks: Project Number|Project Name|Named Resource 2|System Remediation|Jack Sprat 2|System...

Yep...all there. I'll keep checking through it. I think I had some problems with the named ranges. A lot of them were dynamic, and, I think that was throwing it off. I've since made them non-dynamic, and, will play around today...Will keep you posted!! 3G

Yes. And my bad...PMonths is $R$3:$BM$3

Hey Jeremy- Here's what I've got...But, I'm getting an N/A (yes I am Ctrl+Shift+ent) =IF(SUM((LPNum=RProjNum)*(PMonths<PStart)*(LOE_Hours_All))>0,"Mismatch","Ok") My Named ranges are as follows: LP Num -project # in sheet 2 (multiple lines per project) RProjNum - (A3) Sheet 1 (1...

Thanks Jeremy! Will give this a shot... Luke: Sheet 1 Project#|Start Date|End Date 1|1/1/2011|12/31/2013 Sheeet 2 Project|Jan-11|Feb-11|Mar-11|...|Dec-13 1|15|15|15|...|15| 1|0|10|10|...|0| 1|24|0|0|...|0| So, I want to validate that the hours in the columns of Jan-11 thru Dec-13...

Thanks Asa. Good things to think about

Hello- I have a list of project Numbers, dates on one page (start & End), and, a spreadsheet of months horizontal with hours broken out in the appropriate months. What Im trying to do is match the Start & End dates with the first & last occurence of the data on the 2nd page to make sure they...

Hmm...maybe I didn't make sense. I guess what I'm looking for is a "rule of thumb" when it comes to creating dashboards/charts/data & chart combo reports to fit onto a single page, and be legible. My biggest problem sometimes is that, while the chart "fits" onto a page, the font gets so...

Hi there- I'm struggling with trying to fit a data chart on a page in a 14 point font. There comes a certain point where if I make a cell to tall, or, to wide, it takes the chart and makes it smaller. There is a signficant amount of blank space on the page, and, I want to make the chart legible...

Son of a gun. Thanks Mike. That did it. I was just doing MONTH(TODAY())... Thanks!! 3G

Hello- Trying to set up a chart of rolling months based on the date. I've consulted the post on the rolling months, and, have changed teh COLUMNS to ROWS (my data is organized vertically so I can do a specific chart). However, rather than selecting a current month, I just want the date in A1 to...

So, thanks to this board I'm on the up and up when it comes to nifty formulas, dashboards, and other presentation layers. The one thing that I am wondering is that if there are any basic reccomendations people have as to how to organize your spreadsheets? I've seen some folks say have a "data...

Luke- I see where E>D works out, but, I'm having a problem with when the times span midnight. For example... E2+IF(E2<D2,1,0)-D2 ('=23+0-18=5) - Sure no problem E3+IF(E3<D3,1,0)-D3 ('=(6+1)-23=-16) - Bit confused can you explain real quick? Sorry if this is a basic math...

oh brother...that was easy! thanks Luke. where is the embarrassed emoticon when ya need it?

Hi there- I have a few columns of dynamic named ranges, all of which have the refernce set to: OFFSET(Reference, 0,0,COUNTA(Col:Col),1) When I am clicking within another series to create/add an additional dynamic named range, the ranges of previous existing ones are changing ther values...

Ok, now that I have my charting issue resolved, I need to add some data labels. In a cell placed directly above the stacked column I have the following: ="Current Total: "&(ROUND(('(t)Hours By Role'!E71),0)) The number displays as 34345, when, I need it as 34,345. How can I format this cell...

Thanks @Luke!!! As always you're help is appreciated... Hi OleMiss, yes. Luke's article link pointed out a key flaw with my data organization.

I'm not getting a chart...it doesn't seem to work when I pick this combo of data. I can get it for say, projected only, or, actual only...just not BOTH on the same graph.