• 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. A

    Selecting on figure from many to several entries

    Hui, OK, let me describe the scenario. I have, say, 100 products, and each product has a logo. On one sheet, I have 100 lines, with the logo image on A1:A100, and the name of the product on B1:B100. On other sheet, through some calculations with other sheets as well, I have dynamic results...
  2. A

    Autofill Formulas Horizontally with cell number increment

    Holdsworth, You can do it with offset(). Create a line over the line you want the answer with increasing numbers (1,2,3...) (starting on C1, for instance). And let's presume the series you want to subtract start at A2 and B2. So, insert the following formula on C2...
  3. A

    Selecting on figure from many to several entries

    Hui, Thanks a lot for the comments. My main problem is that the image labels are dynamic (change from month to month). So, it's not possible to refeering the images manually, since they're going to change often, and the reference should reflect that - I'll not be in control of the spreadsheet...
  4. A

    Selecting on figure from many to several entries

    Following the advice posted at http://chandoo.org/wp/2008/11/05/select-show-one-chart-from-many/, imagine I have hundreds of calculated fields resulting in a name, and I want for each row to have a figure correspondent to that name. The technique of attributing a getChart formula to an image...
  5. A

    Chart color link to data

    numberland, if you understood you correctly, there's a nice tutorial by Jon Peltier about that: http://peltiertech.com/Excel/Charts/ConditionalChart1.html Basically, your create several columns of data, and for each column you put the data you want with each colour (use formulas to...
Back
Top