Search results

Hui off the track, I want to know how do you guys manage a different font as shown above in your answer? The code you mentioned has different font then rest of the text.

You guys Luke, Hui & our Chandoo are real champ! I knew I would have never got the solution so fast else where. Thanks for making us awesome guys!!!

Hi All, I would like to know is it possible to have data labels & their repective percentage together in column or bar chart. For example 5,10,15 & 20 is my series. I want to show my data label as 5 (10%), 10 (20%), 15 (30%) & 20 (40%) respectively. Thanks in advance for looking into this!

Sample data is not explaining the problem clearly to me... Sorry about that.... To share file with us... You can upload file to any free file sharing website... I use http://www.keepandshare.com/ and then share the link here...

Can you post a file or some sample data?

You can do this by using VLOOKUP...... if you want! ColA ColB PBT IFee 0.1PBT 0.1IFee 5PBT 0.105IFee 10PBT 0.115IFee 15PBT 0.135IFee 20PBT 0.175IFee 30PBT 0.2IFee 50PBT 0.25IFee If your PBT is in cell B11 and you need the result in Cell C11 you can use C11...

Hi all, I don't know even ABC or VBA, though I want to learn it really quick. Please suggest any website (free) to learn it real quick and easy. Prakash

@Vinu: I am confused, why you used advance filter when you can acheive the same result using Filter option! BTW this is good thing to learn, Thank Luke for the input. :)

I remember last time Chandoo started a post mentioning links to some good excel websites. I request you guys to post links to good forums where people discuss Excel (not much of VBA) queries and help each other learn faster. Best! Prakash

I believe you are not using Excel 2007 or later as I am trying this in 2007 and it is working fine!

Thanks Govi! it is simple you will have no prb understanding it :)

http://www.keepandshare.com/doc/2589030/prakash-solution-xlsx-february-10-2011-1-32-pm-37k?da=y I hope this is what you were looking for! Let me know if it helps :)

can you explain it little more? I m confused why you have used the range F9:V9 in sum if to get 106

Mine is Chandoo.org and will always be! :)

Awesome! Thank You Hui :)

Dear All Experts! I want to populate some data from sheet 1 to sheet 2 but the data is date and in columns of sheet 1. I want to have only weekday (no sunday, saturday) in sheet 2 but in rows. Also there is some time associated with each student each day, I want to show that time as well...

Thank you Luke! Must say you're also awesome! Either there some prb with my connection or don't know what my post are getting duplicated.... Please bear with me........ really sorry again

Thank you Luke! Must say you're also awesome!

But the problem is that dial represent the value 1, while in the gauge we want the Gauge Value to be associated with it! I am having problem aligning both together.... :(

Luke I want know how Chandoo has associated the label with the dail. I am trying but is not moving with the dial. Please help!

With reference to http://chandoo.org/wp/2008/09/09/excel-speedometer-chart-download/ I would like to know, how can I make adjustment for data label in such way that it move with the pie chart? As in this example it is moving with the speedometer hand created using a pie chart. Thanks in Advance!

Bingo! Thank You Luke_M

With reference to http://chandoo.org/wp/2008/03/13/want-to-be-an-excel-conditional-formatting-rock-star-read-this/ I would like to know how can I insert ▲, ● and ▼ in my cell. I tried searching them in the symbol section but couldn't locate any. Chandoo has talked about some appending, what...

Fred: "FALSE" is for Exact match while we use "TRUE" for approximate match! I am glad to be of help to you. :)

Fred, This can be solved using VLOOKUP but for that you will have to make small adjustment to your data, if that is possible. Take the lower limit in the interval in column A and price/unit($) in Column B as: Qty(A) Price(B) 1-----100 51------98 111------95 241------91 296------86...