• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results for query: sites.google.com

  1. The following words were not included in your search because they are too short, too long, or too common: com
  1. P

    Project Planner

    To see what is possible, you could take a look at Craig Hatmaker's PapaGannt workbook PapaGantt - The Big Daddy of XL Gantt Charts - Beyond Excel (google.com)
  2. GraH - Guido

    Tree map with Conditional formating

    ...is as open as "Can you buy a Ferrari with money?" Tree map is not a standard chart type in Excel 2013. Then again, all charts can be reduced to an X/Y scatter if you know the maths behind. Example can be found here. https://sites.google.com/site/e90e50fx/home/square-chart-and-treemap-in-excel
  3. B

    Displaying search results from my data

    Hello Chihiro. Thank you for your great suggestions. I have been searching on Google for some ideas. Do you know of any sites that have example workbooks that i could download and play with? Cheers. ;-)
  4. Harry0

    Charting who searches for excel

    On google trends what people care to search for about the word excel excel 2019 excel calendar 2019 excel mouscron (soccer club) pdf to excel convertor Countries that search for the word excel the most = St. Helena China Singapore Colombia Guatemala US is 34th the least= South Korea...
  5. J

    Parliament Chart

    Do you have any such template?
  6. V

    Parliament Chart

    Maybe next You would like that someone else would do it for You? Here should find needed: https://sites.google.com/site/e90e50charts/home
  7. H

    Create report from the table by the format of the cells

    ...the formulas; But I have hardly had success! The most repeated is: https://arxiv.org/ftp/arxiv/papers/1704/1704.01142.pdf https://sites.google.com/site/beyondexcel/project-updates/multi-cellarraymodelling And within the Forum I have only been able to find these three implementations of the...
  8. P

    Create report from the table by the format of the cells

    ...but it is not exactly follow along step-by-step training. Again Craig Hatmaker has described some of the methods I use (https://sites.google.com/site/beyondexcel/project-updates/multi-cellarraymodelling) and he also has interesting things to say on Names and transparency. I have published a...
  9. P

    Question about how to explain concepts to non-technical people

    @MSC Bobs If you want an ally, Craig Hatmaker https://sites.google.com/site/beyondexcel/home is a strong advocate of the methods you propose, even applying them to financial models as opposed to data analysis. Some things are on your side in that it is becoming easier to cope with cross-tab...
  10. V

    Generate QR Code From MS Excel

    Azman Ali M.Habib Rahman Have You checked next links? >> How to Create QR Code List for MS Excel https://sites.google.com/site/e90e50fx/home/generate-qrcode-with-excel >> Or this? http://www.keepautomation.com/products/excel_barcode/barcodes/qrcode.html
  11. Hui

    Pairs of numbers

    There is also a good discussion about combinatronics at: https://sites.google.com/site/e90e50fx/home/combinatorics-using-excel-formulas-and-examples I'm not sure how applicable it is to your problem
  12. GraH - Guido

    Fully Customizable VBA Date Picker

    ...memory, but the girl and guys from The Frankens team*developed a calendar control for all office versions, including 64 bit. https://sites.google.com/site/e90e50/calendar-control-class. They updated it in 2017. * Roberto Mensa, one of the three members, has a user account over here, but...
  13. P

    The A1 notation is an abomination that has no place within serious spreadsheet design -- discuss?

    ...that is. Craig is a leader when it comes to Excel, not a follower. To form your own opinion take a look at his blog https://sites.google.com/site/beyondexcel/home I could spend months there! It is what happens when an IT professional meets and adopts Excel. A fairly recent and, to me...
  14. G

    Merge data from multiple spreadsheets into one master sheet.

    ...terminology but i tried to explain it as best i could. as i said i have found a solution that i was able to modify from: https://sites.google.com/a/madrocketscientist.com/jerrybeaucaires-excelassistant/merge-functions/consolidate-wbs-to-one-sheet i do not know how to correct the table to...
  15. Harry0

    How do I get excel to input automatically from online?

    I am trying to get info from online sites automatically and refresh it but it does not work to crash or can not read it. It can reference a blank page perfectly but then that defeats the purpose. LOL How can I make something work? If it does not wokr on one site maybe another but still I don't...
  16. P

    Gantt visualisation challenge

    @torben You might like to have a look at Craig Hatmaker's site for ideas https://sites.google.com/site/beyondexcel/project-updates/papagantt-thebigdaddyofxlganttcharts Craig is of the mindset to contribute to the community so would be supportive. Quite a while ago, I set out by placing shapes...
  17. Hui

    Speedometer Chart

    Have you had a look at the templates at: https://sites.google.com/site/e90e50fx/home/compound-pie-radar
  18. G

    VBA for open multiple webpage in new tab (IE)

    HI Everyone I have a VBA Code to open and auto login a separate web pages (Nearly 10). i need to open all these macros with single click, so i have call all of these macros by button. the problem is this all are opening with new internet Explorer application. What i need is when i click the...
  19. N

    Excel Chart - Pivot Chart

    ...for what are called slope graphs. See these links for more information : https://peltiertech.com/slope-graphs-in-excel/ https://sites.google.com/site/e90e50fx/home/Edward-Tufte-slopegraphs-in-excel http://stephanieevergreen.com/slopegraph/...
  20. N

    More learning for today

    Hi , All those who use Excel at work can make use of these techniques : https://sites.google.com/site/beyondexcel/project-updates/multi-cellarraymodelling Narayan
  21. Hui

    how to get all possible combinations from six columns

    maybe have a read of: https://sites.google.com/site/e90e50fx/home/combinatorics-using-excel-formulas-and-examples
  22. Hui

    Sunburst Chart - VBA Formatting

    ...help? http://chandoo.org/wp/2012/07/02/how-to-make-a-spoke-chart/ or http://www.excelhero.com/blog/2012/05/excel-formulas-can-make-a-graph.html or https://sites.google.com/site/e90e50fx/home/infographic-chart-with-excel https://sites.google.com/site/e90e50fx/home/sunset-end-of-summer-excel-chart
  23. Chihiro

    Scrapping - blocking by internet explorer

    Well, without your code it's hard for us to help you. If you are piloting IE, then you should not get hit by Google API's limit on transaction. This happens mostly when you use XMLHTTP to send requests directly to Google server(s). Try turning off XSS filter in IE (Google search for it and...
  24. S

    Scrapping - blocking by internet explorer

    good morning. I have a macro to extrapolate data from google. Recently when I used it after a few moments I appeared to have an empty white page. I updated the page and below I appeared this message: This is the translation: Internet Explorer has edited this page to prevent potential script...
  25. T

    Trouble with Excel Macro Auto Login

    There is some great information on this web site however I haven't found a solution yet. I have been trying to use a Macro in VBA/Microsoft Excel to auto login to a web site automatically and fill in information into the web page. On the up side I'm able to do this on several different web...