Search results

:DD:DD

Hello friends.. I have added a welcome notice that will be shown until a user reaches 5 posts. It looks like this:

Hi Chippy... you can use your personal preferences to automatically watch threads where you post a reply. This might be a very convenient option. Just visit http://forum.chandoo.org/account/preferences and check the first box. I will see if the watch thread option can be integrated to quick...

Done... Coming soon: notice & message to first time visitors & new users about our forum policies, posting guidelines. This will be shown until users reach 5 posts.

I am also investigating a plugin that can display new threads, new posts, most viewed and replied threads in the home page. This will make navigation and discovery easy.

What?!? We have "Ask an Excel Question" button?:eek:

Jokes aside... I know I can never compete with any of our ninjas or frequent members when it comes to answering questions or being nimble. But I try, once in a blue moon :)

Also see, http://chandoo.org/wp/2008/08/14/plot-time-series-data-excel/ for alternative representation of this type of data.

See this as a start. http://chandoo.org/wp/2013/05/28/excel-risk-map/ coming to your data, You should first divide the numbers to 5 series (since you have have 5 types of bubbles). Once you have them, create a bubble chart. Then, Format each series in the color code you want. Create a 3x3...

Hi Data Dame... Thanks for the question and happy holidays to you as well. Since you have not provided any sample data, my suggestion is to use either a gantt chart (with conditional formatting) or scatter plot with error bars. See this examples for some inspiration...

You can use running totals feature in Pivot table to get this. You will have to re-adjust your source data. Have a column with complete date instead of month and year in separate columns. Then you can right click on the pivot table value field (addition) and choose "Show values as" and select...

3 things come to mind. 1. Seems you and IF had hit a rough patch. Did she ditch you for a hot, manly VLOOKUP in a dance bar? 2. Use advanced filter. This can extract all positive numbers and place them in a separate range or sheet. 3. Use =MAX(number, 0) if you just want to suppress negative...

Congratulations on your first job @tarynmahon When I got my first consulting project, I was not sure how much to charge either. So I reached out to my mentor (Jon Peltier) who gave me some valuable advice. Since I had a full time job (and was doing consulting project mainly to enhance my...

Good discussion... Here is what I suggest: Break your dashboard in to at least 3 components - Data, calculations and Dashboard output. Maintain individual components in separate sheets. Create a template-like version of the dashboard. This would show the output dashboard based on data &...

Here is something that is close enough.. obviously it requires a lot of formula magic... https://sites.google.com/site/e90e50fx/home/talent-traffic-chart-with-chord-diagram-in-excel

Also keep in mind that any time you use INDEX in a reference with : operator, it becomes quasi-volatile, meaning the reference gets re-calculated on file open, save etc.

In your example you say "assume this is a pivot table". If so, why not use GETPIVOTDATA? This exactly does what you are looking for without any fancy dynamic reference formulas...

Can you confirm if your Excel question is answered or you need any more help?

@Giantpegasus Welcome to Chandoo.org forum. Please note that everyone here is trying to help you. That said, none of us are obligated to help you. So please be nice and ask gently. You may be in a rush, but practically no one on internet cares about that. Regarding your question, you can set...

This is not possible with formulas. (you may be able to write some circular reference to work it out, but it is not worth it). You need to have a macro that can archive the values everyday (or everytime you open the dashboard and press some button). The basic approach is like this: After the...

@Speer... You can use this formula... =INDEX($B$1:$V$1,MATCH(TRUE,(B2:V2)>0,0)) Press CTRL+Shift+Enter to get the result. PS: Just saw Kanti's solution. Good one :)

Yesterday, It happened to me as well. I thought it might be a cookie issue. I guess it is back to remembering :)

Have you tried the option "keep me logged in" when logging in. This should keep the cookies alive.

This is a old Excel 4 macro function. MS kept it for backward compatibility reasons. See below pages for help on GET.CELL() http://www.mrexcel.com/forum/excel-questions/20611-info-only-get-cell-arguments.html And if you are using Excel 2013, you can do the same with this formula...

I think a better way to split would be to calculate days per financial year (rather than months). This gives accurate split. See attached for a solution. The basic approach is like this: For each financial year, calculate how many days need to be considered. Then divide this days with the...