Recent content by Robapottamus

Hi I have a set of charts with titles that appear to have lost their dynamic links. They link to cells on a separate sheet. has anyone had this issue before and know how i could fix this? Currently each week on a Friday i go into the workbook, and restore the links individually (approx 50...

I am not sure i understand your problem correctly - would the =SUMIF function help you?

No worries Kim, yes it pays to keep it to minimal / simple change where other people are the primary user. Have you tried adjusting your initial formula to the following: =IF(OR(C4="D01",C4="D08"),IF(OR(C4="D01",C4="D08")*AND(I4<50),I4,50),"") that may eliminate the helper column

Hi Kim The way I would approach this would be to use a helper column. There is probably a way to do this all in the one cell, but i find helper columns a good way of seeing the in-between steps. Try this: 1. Create a lookup table of all of your twenty (approx) codes out to the side or on a...

Hello I have a scatter plot that I prepare monthly, comparing our supplier performance across two variables, both in percentages - a quick way of identifying our poorest performing suppliers. The trouble is it can get quite messy in that there can be approx 200 suppliers on this chart each...

sorry, rushing, got my letters mixed up in the formula. Replace with: =if(and(a1=1,b1=5,c1=11),"Yes","No).

Hi There This might be a work around, but is relatively formula and method to follow (for me anyway): I would firstly create a helper field in the next available comlumn (I assume column D, titled "Yes/No Flag") using the following formula: =if(and(b1=1,c1=5,d1=11),"Yes","No). Then you can...

Hi Narayan Yes it is a strange problem. After ticking the "Don't Move or Size with Cells" option it seems to have solved the problem for myself, however the problem appears to still prevail when other users have been in the spreadsheet. I wonder if alternative versions of Excel have something...

Hi there Jaefo the answer to your question could be as complex or as simple as your project is i guess. To clarify, are you after a simple sum of the individual task durations? Or are you after techniques for visualising the project timeframe? Chandoo has a Project Management course coming...

In addition to my post above, if your data runs across multiple years, then you can use the formula =year(A1)&" "&month(A1) to identify the year also. Could use this instead of the month formula suggested above.

Hi There An alternative suggestion so you don't have to change your current data is to insert a new column with the formula =month(Cell reference), linking to your date column. This would mean that you can keep accurate records of which day the sale occured while still summarising by month...

Hi There I am revisiting this post as the above fix appears not to have resolved my issue. The chart titles are still reverting back to their initial font size (way too big). All of the charts have the "Don't Move or Size with Cells Option" ticked. Any other suggestions I could try? The...

Hello - I have a similar problem that I am working with. Robert, did you find a solution in the end? I am not sure if it is appropriate to post an extension question on an existing post so please advise if I should start a new one... For application to my particular problem i want to have a...

Thanks Hui, that seems to have worked at this stage. As an aside, I wonder what the solution would be if I only had 1 chart, as "Size and Properties" appears to be only accessable when multiple charts selected?

Hello I have a large number of charts, of which the titles are driven via a formula linking to their relevant cell on a separate worksheet. For some reason, the titles have decided to default themselves to size 18 font rather than my desired size 12 font. This means that every time i reopen...