Search results

Hello Dear Friends, Could you please kindly suggest a lookup formula that refrences to a pivot tbale attached ? Thanks Dumbo

Thank you very much Narayan. Exactly what i wanted

Hi Friends, Could you please refer the attached file and suggest a lookup formula which need to reference values from two columns ? Thanks

Hi Friends, Could you please kindly refer the attached worksheet and help advise the change i need to make in the given formula, if need to put a upper limit. Thanks heaps Excel Dumbo

Thanks vijay, text to columns will work too. just fascinated with formulae

Thanks Hui and XL Padawan

Hi Friends, Could you please suggest two formula that will give me numbers only in one column and characters in another column 20001 SYDNY-BRIDGE 2002 SYDNY-CHINA 203 SYDNY_WYN 20700000 BROADWAY there are spaces before the characters thanks heaps

Thank you very much HUi for your wonderful help with my questions

Thanks HUi

THanks Hui. I figured it out. Thanks heaps for all your help today and yesterday

HI Hui, I saw the secondary series and applied it to the budget. But how do I make the bar appear inside or outside the actual bar ? that will look like a thermometer. At the momement my budget bar is not appearing within the actual bar

Thanks Hui but that does not seem to be working for me. I have attached my file here. Can you please look if you have some time. Thanks heaps for all your earlier help

Hi, I have applied a format to my data label $#, K which shows the values like $90 K, $20 K However I have few blanks/or zeros appearing in the data series. For those data, it appears as $ K on my graph, i would like to see it as blank on the graph but stick to the $90 K format for whereever...

Thanks for this HUi. How did u prevent #N/A values from not appearing on graph ?

HI Hui, I have posted in the other topic, please see when you get some time. One last question regarding the file you solved above. I would like the Variance to be (Actual/Budget)-1 and to appear as %, when I did this, variance bars are refering to Dollar values on Y axis, how can i create...

Hi Hui, Coming back to this again please. If you notice the attached file you had solved for me, in the Mthly tab, Row 2 , column O, P and Q show forecast , and the months before are actuals. I would like the budget remain as it is. I would like to show the bar columns for O, P and Q as dotted...

Thank you very much HUi. This is exactly what i wanted. But I have one more question in an example who had solved for me. Graph you had solved yesterday (link in your post). The month of July is a forecast. How Will i change the column bar just for the month of July to Dotted lines

Hello Friends, Could you please kindly refer the attached file and kindly help advise how to build a variance chart as shown in the sheet ? Any help will be greatly appreciated. Regards, Excel Dumbo

thanks a lot hui. i figured it out. thank heaps for your help

I got it Hui. Thanks. Can you please see the file I have saved in the link kindly advise where i went wrong. Cant figure out the problem here.I have reached the last stage. The drop down menu is not pulling out the right numbers on the graph http://speedy.sh/P6eXD/Graph-Query.xlsx

Thank you very much Hui. This is exactly what i wanted. if you could also please let me know how to bring in the drop down menu in chart

Hello I am new to charting, If any of you could kind refer the attached spreadsheet and help draft a graph that compares Actual vs Budget of NET IT Expense with Periods on Y axis. And to introduce a drop down menu in the graph to select the highlighed subtotals in grey (Net FTE Costs, Net...

Thanks Somendra and Narayan.

Hello Dear Friends, Please refer the attached worksheet and I am pulling my hair out thinking of a formula which when matches the given % should give out the required conditions. Any help will be greatly appreciated Excel 2010

THank you very much narayan