Search results

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

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

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

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

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

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

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

Hello, I want to separate text that is all one one cell. I'm familiar with the text to column with the delimiters and fixed width. The fixed width works very well, but not all text is lined up appropriately. An example of a text is: Smith, Carol 3334 S. Camelot Way, SLC, UT 84012 (I want to...

I have a spreadsheet of data and one of the columns on that spreadsheet is the month. I enter the month data as January, February...etc. so I just do the month name. I do this so when I create my pivot table, I can look for data for that particular month. When I drag the month over to the pivot...

I'm trying to return a specific statement depending on what cells are entered. If someone puts text in A7 then that returns a text I want so that was: =IF(ISTEXT(A7),E2,"") Then if someone enters text in A7 and B7, then that returns a different text I want so that was...

I have to create a list or a "database" of signs where I work. I'd like to include a picture of the signs and fields that relate to the signs (size of sign, font, floor located...etc). If a sign needed to be updated, then I can simply do a search of a word that would appear on any of the signs...