Search results

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

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

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

May I send you my file?

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

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

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

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.

Hi, I'm trying to keep inventory of some things that I record in a table. I want one cell that will show me my current inventory everytime I record my inventory in the table. Here is an example: C3: =If(C14="oranges",(100-D14),IF=(C14="apples",(500-D14))) Where my value 100 and 500 is my...

I loved today's post b/c I have been trying to see if I can do a rolling 12 automatically. I maintain a dashboard that is a rolling 12. Currently, when I need to add the new month, I create a new tab, I insert my column and add that new month and I also drop the first month since it's rolling 12...

Thank you Hui. If you had to choose a detailed chart from the charts submitted on that post, which would choose? I am going to be creating one for my work and am debating which one. I really like the dynamic charts and may go that route.

I was reviewing the charts in the April 2009 post on budget vs actual. I really liked #6 because it was very simple. How would one go about creating a similar chart? How do you put the solid line above or below the bar graph? Thank you. Below is the link to the post...

Thank you Hui for your suggestions. If I do the one large table then can I still do a vlookup? I have to see if the licenses I collect will match the new set of licenses I get each day. That's how I know if the same car is still illegally parking. Thanks again for your help.

I currently track cars that illegally park in a parking lot. I get data everyday and I cross reference existing data to new data I get by using the vlookup to see if I get the same car that illegally parks. My data I get each day is stored in a tab in my worksheet but I'll be tracking this for a...

How would I write the IF formula if I am trying to determine if the first number starts with a certain number? I want to say all the numbers that start with a 0 get assigned the "Red" and if another number doesn't start with a 0 then it would "Blue" Example: 00234 00485 00848 93040 50393...

Never mind...I just found something about creating multiple combination charts with varying values. If you find something else, let me know...

I need to compare two data sets in a line chart (I'm figuring the line chart is the best thing to compare two different data to see if there is a correlation, but let me know if it's not). My question is that the two data sets are in different formats--one is a percentage and the other is a...

Thanks Hui. I'll ask the person who gave me the list to configure the list so it's easier. Thanks again for your help. How did you get so good in Excel?