• 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

    Hui...

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

Search results

  1. R

    Creating horizontal bar charts by repeating a symbol? [SOLVED]

    I tried to change mine, but cannot login to gravatar.
  2. R

    Conditional Large Formula [SOLVED]

    Those array formulas are really useful - just getting to know them myself. Tim
  3. R

    Hiding lines using Excel Tick boxes

    The 'move and size with cells is greyed out - because I was using the form controls check box. If I use an active X then it hides with the cells. Excellent - that should work. Thanks Tim
  4. R

    Recreate SUMIFS and COUNTIFS from Excel 2007 as UDFs in Excel 2003?

    See http://chandoo.org/forums/topic/converting-sumifs-to-excel-2003
  5. R

    Pacman Chart [Charting fun]

    I must find a way to include this in a future presentation!
  6. R

    Distracted Driving Visualisation

    I would strongly advise people to do what I do - lock the phone in the boot (US: trunk)! Even talking to a passenger while driving can be too distracting when there are lots of other cars about and something unexpected happens. My wife is used stopping talking - even mid sentence - when a...
  7. R

    Conditional Large Formula [SOLVED]

    Just to clarify, do you mean 'the Nth value in column A of all that match where column B meets the criteria' or 'the Nth value from column A, only if it meets the criteria from column B'. I'm guessing the former as that makes more sense. If that is right, here is a really messy way of doing...
  8. R

    How do I efficiently chart 200,000 data points

    Graphing that many data points is unlikely to show anything of interest, except for a real mash of lines! It will be extremely slow in Excel, too. So, you should aggregate the data - that is, reduce it to a smaller number of points by 'combining' values by taking their averages. So, you...
  9. R

    Hiding lines using Excel Tick boxes

    Hi I am playing about with Excel to do all sorts of things, and have found tons of ideas from this site - great work. One thing I am trying to work on is a 'Tick List'. I have no problems with creating the tick list and hiding rows depending on values. However, I want it to be mouse...
Back
Top