Search results

Hello, How can we conditionally choose data for charting? I mean for a certain value, a chart will be made for a range of cells, for another value the chart will be for another range of cells, but appears in place of the first chart. I hope I am clear.

Hi, Could you please help me program a find button in excel 2010 step by step?

In A1 I have a formatted text ( underlined, coloured ... ), in B1, I have this formula (=A1), but the result is just the text without formatting. How can I get the text with all the formatting in B1?

Hi

The =IF(OR ... formula accepts only 64 threads. Is there any way to double that number?

Good start, Debraj, Now, suppose the chart vertical axis is between 0 and 100. When the interactive column rises above 50 it has one colour, and when the same column changes to a value under 50 it will have another colour. Can this be done.

Dear DEBRAJ, Thank you for your valuable reply. What I actually mean is that the columns in the chart change colour when they get shorter or longer according to the change in values. This is for interactive charts.

How can we conditional format charts so that the columns change colours according to given values or ranges?

Hi all, Please look at this file: https://skydrive.live.com/redir?resid=D2EB358351CED728!113 When you click anywhere on the text, an image of it pops out. How is this done?

Hi all, I have a workbook of several worksheets. I have a worksheet at the beginning with an index to all the other worksheets with hyperlinks. When I click on a hyperlink, the related worksheet opens. Now I want to hide all the worksheets. I did this. But when I click on the hyperlinks in the...

Dear all, I am using a regular laptop with windows 7. I can see an on-off button at the bottom of the page, yet it does not do anything.

Thank you all.

hi SirJB7 Thanks for the tips. What is chandoo doing right now at the park :) I have windows7

hello all my browser showcs chandoo blog like mobile style. Can it be changed to the original PC view?

Thanks Luke M I am not that fan of VB codes. Can this be done without codes? Just with formulae? I have the 2010 version of excel.

3USD 4USD 5USD 6USD BOOK EARRING NECKLACE BELT BELT BOOK FLASH MEM BOOK I want to sort this data like this: BOOK EARRING NECKLACE BELT FLASH MEM 3USD 4USD 5USD 6USD...

Hi all, I have a worksheet that have about 5000 entries. These have to be filtered according to different criteria. Now, I need to have a cover page with buttons. Each button is named after one of the filtering criteria. When this button is clicked, filter is applied and the result is shown in...

How can we extract numbers from cells that contain both text and numbers and put the numbers in separate cell?

Thanks a lot kaushik03 Can I include numbers as well? How?

Ihave alist of items in alphabetical order. I need to put new records in order automatically when i add them at the end of the list.

Thank you all. I solved the problem by having a regestry file.

Good point, Chandoo; But the problem is that the names in columns B:F are changeable. John may be a doctor once, but a businessman next time - This is an example, of course - How can we make a formula that follows the change in profession for the same name?

Here's a sample file for your concern, Hui http://www.4shared.com/file/9M9txbcP/sample.html

Thanks both of you. But the problem is not solved . I know the links you provided me before but they are about Outlook and Internet hyperlinks that do not work. My problem is far away from the Internet. It is that the hyperlink in my Excel 2010 workbook do not work, althoough they used to work...

I have a table of 20 rows and 6 columns (A1:F1) Headings: A1 (NAMES ) , (B1:F1) PROFESSION1 to PROFESSION5. The names are then distributed in the table according to nationality. I need to create another table from the original one in which I want the A column showing all the names, and instead...