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.
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?
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.
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...
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...
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?
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...