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

Recent content by maradykstra

  1. M

    interactive chart using combo box and check box

    Hui, I have months to my data. I can send you the file? I think you've helped me before with something and you had me send it to your email address. I can do that again if you like? I have all my data laid out already.
  2. M

    interactive chart using combo box and check box

    Hello, I'm trying to create an interactive chart using a check box and combo box. There is an example on Web Analytics http://www.webanalyticsindia.com/2008-12-17/dashboard-design-tricks-using-combo-box-for-a-neat-treat/ but I can't see to connect the check box to the combo box (sorry still...
  3. M

    Interactive/Dynamic Chart

    I just sent it. Hope you got it. Thanks.
  4. M

    Interactive/Dynamic Chart

    Here's my data for two months but I'll have to do it for all the months later: Chocolate Vanilla January Week 1 50 100 January Week 2 25 89 January Week 3 67 45 January Week 4 15 25 Febuary Week 1 37...
  5. M

    Interactive/Dynamic Chart

    May I send you my file?
  6. M

    Interactive/Dynamic Chart

    Hello, I am building an interactive/dynamic chart. I want to show the performance of sales to my staff. Let't say they are selling chocolate and vanilla. I want to show how well they are doing each week within the month. I've created a drop down with all the months before where you pick the...
  7. M

    background color in Excel

    Those are very good points. I will consider those. Thank you. I will try and see if I can do a background color. It's always nice to give the audience options b/c sometimes they don't have a preference. As always, thank you Hui!
  8. M

    background color in Excel

    Wow...that sounds like a lot of work. I'm creating my first dynamic dashboard and am excited to finish it so I thought I'd try to get a slick background but I think white will do. Do you have a preference of what color background is best for a dashboard? Do you think adding a color will be more...
  9. M

    background color in Excel

    Hello, I saw the post on personal expense tracker. Option 1 looks really cool. I know how to do a background fill but how do you do that faded color from blue to gray? Here's the link below. Any help will be appreciated! http://chandoo.org/wp/2010/07/16/download-expense-trackers/ Thanks.
  10. M

    getting values from combo box

    Hello, I have a list of months (Jan-Dec) with data next to each month. I created a combo box and specified the range and the cell link. When I choose a month from the combo box, I'd like the data for that month to appear but it's not working. Do I need to put a formula in so the combo box knows...
  11. M

    Getting the data from picking a certain month

    Thanks Hui. I actually thought of those two functions and I think the Index will work too. Thanks for your reply.
  12. M

    Getting the data from picking a certain month

    I have a list of products with amounts in a table. In another worksheet, I want to pick a month from a drop down list and then it would show me the totals for all my products from my table. How would I do this? Should I use a combo box to do my drop down or would it be okay to use a data...
  13. M

    inventory tracking

    Hui, Thanks for all that information. I'm actually utilizing almost everything you listed. I also am enrolled in Chandoo's excel school. It's been so helpful. I love it. I think the hardest part is remembering the formulas. It seems as if there a few ways in obtaining the answers. I think I...
  14. M

    inventory tracking

    Thanks Hui. So do you have every excel function memorized? As I was doing this, a few functions crossed my mind...If function, vlookup, sum...etc. Would you say the more functions that one is familiar with the more options and best options you can choose to solve the problem? I didn't even think...
  15. M

    inventory tracking

    Hui, Thank you so much for that. It worked great. Can you explain to me the sumproduct formula and what that +1 means in the formula? Thanks again.
Back
Top