Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: CCNProjects
  • Order by date
  1. CCNProjects

    Several Column - line graphs next to each other

    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.
  2. CCNProjects

    VLOOKUP works aonly for the first row

    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...
  3. CCNProjects

    Several Column - line graphs next to each other

    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...
  4. CCNProjects

    Several Column - line graphs next to each other

    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...
  5. CCNProjects

    grouping in pivot table

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

    grouping in 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...
  7. CCNProjects

    Need to show headings for the first 3 pages only - excel

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

    Need to show headings for the first 3 pages only - excel

    Thanks.
  9. CCNProjects

    Need to show headings for the first 3 pages only - excel

    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.
  10. CCNProjects

    how to add more colors in Excel

    thanks.
  11. CCNProjects

    how to add more colors in Excel

    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)
  12. CCNProjects

    split cell - again!

    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.
  13. CCNProjects

    split cell - again!

    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%...
  14. CCNProjects

    IF & OR

    That was great! Thanks.
  15. CCNProjects

    IF & OR

    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.
  16. CCNProjects

    image as a background in Excel chart

    Thanks to all.
  17. CCNProjects

    image as a background in Excel chart

    Thanks. It worked.
  18. CCNProjects

    image as a background in Excel chart

    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.
  19. CCNProjects

    Unique records

    Thanks
  20. CCNProjects

    Unique records

    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.

Part and Inventory Search

Back
Top