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