Search results for query: *

Thanks again. I would like to have US next to Russia, for example, on the X-axis. Then, have the bars (quantity) and the line (value)for each country on the Y-axis.

Hello, My VLOOKUP formula ( VLOOKUP(B2,key2,4,FALSE)) works only for the first row, i get "#N/A" for all other rows. I should get the same outcome for the first 10 rows (same individual), but I get the right result only for the first row. My identifier column (common column) has been sorted...

Thanks for your reponse. I was not able to follow your advice, for excel does not allow me to graph more than 2 series with 2 axis. What I want to do is like the graph on this page (http://www.slidewrite.com/images/3x1_stackchart.gif), but the 3 graphs would all be on a horizontal line instead...

Hello, I would like to graph the quantities as bars and the values as lines for each country. Would it be possible to align the countries on the same graph? 2005 2006 2007 2005 2006 2007 tons tons tons million yen million yen million yen U.S. 25,866 27,597 16,064 3,936 3,718 3,048 Russia...

Thanks. My problem was my data and not the pivot table.

Hello. I have an excel sheet with the following exchange rate data 01 jan 1999 0.1 02 jan 1999 0.5 ... 30 dec 2007 0.2 31 dec 2007 0.3 I could not group the dates and get an average exchange rate per year. The error I get is: Could not group that selection. I formatted my first column...

Thanks kjv1611. This is what I did. I put the headings in the spreadsheet.

Thanks.

Hello. When an excel document is printed the headings (column titles) appera on every page. I would like the headings not appear on the last page. How can I do that? Thanks.

thanks.

Hello. The number of colors one can use in Excel is rather limited. How may I add more colors (like in Word)? Thanks. (yes I know, it is a weird question)

Thank you very much for your help. I hate to say this, but I don't have any result, only the formula itself. I formatted (Format Cell...) my column, but to no avail.

Hello all. I read the thread about never splitting a cell, but I need to do this. This is what I have: col1 col2 col3 col4 AA 5% 3% xxxx BB 7% 2% yyyy I need to display data as: col1 col2 AA xxxx D5%, C3%...

That was great! Thanks.

Hello. I would like to point out the cell value under a certain condition: if cell A1 or cell A2 is greater than 0.001, then write the greatest value of A1 and A2 in cell A3. =IF((A1>=0.001) OR (A2>=0.001), MAX(A1,A2),"")?????? Thanks for any hint.

Thanks to all.

Thanks. It worked.

Hello. Is it possible to set a picture as a background in an Excel chart? I searched the forum, but did not find any question related to this subject. Thanks.

Thanks

Hello all. I have a column with multiple identical records. I would like to create a column with unique records. Example: from col1 to col2 A A A B B c C B Thanks for any hint.