• 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

    Help visualizing relationships between brands

    Yep those definitely work - conditional formatting is my go-to for these at the moment. Just thought maybe I could get fancy with it :) - people have seen these tables replicated over and over, so I was trying to think creatively about a visual that might turn some heads.
  2. A

    Help visualizing relationships between brands

    I work in marketing we frequently show how many buyers of one brand also purchase another brand, and vice versa. E.g. you might have 4 brands (generally 15-20 though), Brands A, B, C, and D: Brand A: 80% of buyers purchase brand B, 60% purchase C, 10% purchase D Brand B: 70% purchase A, 50% C...
  3. A

    vba code for pop up box anytime a certain sheet is active

    got it! Private Sub Worksheet_Activate() MsgBox "test" End Sub i'm dumb. thanks :p
  4. A

    vba code for pop up box anytime a certain sheet is active

    It's been years since I did anything in VBA code so, although I think this one is pretty straight forward, I can't get the thing to work. I have a workbook with multiple worksheets in it. Anytime the user ends up on the worksheet called "Your Consumer", I want a msgbox to pop up with a few...
  5. A

    bar & line chart: issues with displaying negatives, updating data

    Thanks for the response! Definitely close to what I'm looking for with one small hiccup - if the data changes and, say, cell D2 goes from 280 to 400, because the macro fixes the min/max of the primary axis also, now the bar is appearing off of the chart. Perhaps if I just did this? Button 1...
  6. A

    bar & line chart: issues with displaying negatives, updating data

    This is sort of a difficult question to type out here, so it might be easier to just check my attachment as I included charts with examples of what I'm trying to do. Basically, I have a set of data that will be updating frequently: 5 products, Absolute $ Change, and % $ Change. I want Absolute...
  7. A

    shading chart to show returns above or below average

    Beautiful! After 2 hours of trying last night I gave up, but this is precisely what I was looking for. Thank you (both) so much - the Chandoo website is 1/1 in solving my excel problems. Thanks! :)
  8. A

    shading chart to show returns above or below average

    Hello - hoping someone can help me recreate a chart like in this link: http://postimage.org/image/rtvd3s1jz/ Basically, over a set of dates i have: a series of #s showing what % of a brands volume was on discount, and a series of #s showing % of total store items on discount. i want the area...
Back
Top