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

    Chandoo, I sent you an email but you claim not to read it but once a month. one of your staff...

    Chandoo, I sent you an email but you claim not to read it but once a month. one of your staff members, "bobhc" is stalking my posts, and sending me harassing/inappropriate/threatening private conversation messages. How do your moderate your moderators?
  2. C

    How do I convert an existing Chart to VBA Code?

    For anyone interested, I was able to solve my challenge without having to program the charts in VBA. It was rather obvious -- Instead of simply copying the 'chart' worksheet from the sample file to my new file with VBA code, I copied the 'chart' and 'data' worksheet that the chart referenced...
  3. C

    How do I convert an existing Chart to VBA Code?

    vletm, I uploaded the files to the private conversation you started. Thanks! Casey
  4. C

    How do I convert an existing Chart to VBA Code?

    Thanks both of you. I am relatively familiar with VBA and have done extensive VBA charting/sparkline dashboards in the past, but that was years ago. I figured the easiest thing would be to, as I mentioned, simply populate the data source for existing charts that were created. Not working as...
  5. C

    How do I convert an existing Chart to VBA Code?

    Hi, It's been a while since I have worked with Excel VBA so I'm trying to get back up on the horse. I created a form on worksheet "Admin" to allow user to select multiple text data sources and ingest them (different criteria depending on the file format). These files populate a table on a...
  6. C

    Use Structured Reference to locate value in cell in previous row of table

    This is what I came up with. Please let me know if you have a more efficient method. The formula for the "TestColumnPreviousRowValue" in the original psudocode is: INDIRECT(ADDRESS(ROW(MyTable[AnotherTestColumn])+MATCH(MyTable[[#This...
  7. C

    Use Structured Reference to locate value in cell in previous row of table

    I know how to get the value of an cell in a table if the cell is in the same row using the structure Reference "special item specifier" [#This Row], but I was wondering if anyone had a quick/efficient way of locating a value 1 (or more) rows above (or below) the current row. I figure I will...
  8. C

    Help with Data Filter and Filter Results Table (not range)

    Narayan/Hui, I have implemented the following code which takes the 'n' rows of my filtered data from the hidden 'calculations' worksheet, inserts 'n' blank rows in my instruction form/worksheeet and pasts the values in the new blank rows. I still need to add the conditional formatting to each...
  9. C

    Help with Data Filter and Filter Results Table (not range)

    Narayan, The filter results are posted to an hidden worksheet, so I could use your approach and just perform the count row/copy without deleting the sheet when I am done. I will try it. Hui, The worksheet I want to post the results back to are the 'instructions' sheet for refreshing the...
  10. C

    Help with Data Filter and Filter Results Table (not range)

    I have a filter in my VBA code which works fine, and copies the output to a second table for me to perform additional steps with. Range("Table_Data_Current_Wk_Schedule").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range("adminMilestonesFilterCriteria")...
  11. C

    How do I use VBA and variables to create dynamic import connections?

    Hi Hui! I didn't see your response previously. I am referring to a "Data Connection" to another workbook, not a cell reference to another workbook. Basically, I have tables in my 'dashboard' workbook and part of the instructions have users trigger VBA events by clearing contents of an...
  12. C

    How do I use VBA and variables to create dynamic import connections?

    Bump. If no one has a quick solution, I would at least be greatful for some direction as to where I should begin my research. thanks!
  13. C

    How do I use VBA and variables to create dynamic import connections?

    I have been building a dashboard that, at present, requires strict path/filenames for import files. When I trigger the import refresh VBA code, I want it to update the connection string to use the value stored in the cell referenced by a Name as the path/file. (I am importing .xlsx file type)...
  14. C

    Help with the ShowHelp() function

    I am incorporating the ShowHelp() function that is included in the Dynamic Dashboard Illustration v1.1 file (and instructions). Has anyone modified to make it more context sensitive? I would like to create help buttons on various pages or locations within a page and, based on a parameter or...
  15. C

    VBA to change Header Picture?

    I have done extensive research, and the only thing I seem unable to do to completely format my print page headers using VBA is insert a picture. Ideally I could select an picture object (or cell range) that my end user inserts in a setup worksheet. Does any know a work around for this? I am...
  16. C

    Data Tables, Structured References, and Form Controls

    Hi Dan, This was posted a while ago, but I didn't see a solution so I thought I would reply. I am not sure why a table reference won't work, as you indicated, but if you create a new name for the table reference it works. I did the following: 1) define a table "Table_Names" with one...
  17. C

    Moving Data Table in Chart area

    Thanks Hui and Luke. I did use the Camera Tool to take a picture and place under the chart on my dashboard. This approach allows more flexibility.
  18. C

    Example: Horizontal date entry formula

    Thanks Hui! I updated the .xlsx file to include your improved approach too!
  19. C

    Example: Horizontal date entry formula

    I started to create a horizontal log file that will have 3 values per log entry and unlimited log entries for the 'reporting period'. I abandoned this and returned to a vertical approach... I was really just doing this to learn. If anyone finds it interesting, I'm glad. If any of you more...
  20. C

    Combine Column and Stacked Column Chart Both on Primary Axis

    Got step one okay, but i am confused by what you mean "Then copy Actual row from Actual to Mar". Do you mean right click in chart and "select data", then replace the value for "Mar" in the horizontal axis with the range for the "Actual,12,11,13"?
  21. C

    Combine Column and Stacked Column Chart Both on Primary Axis

    Oh... you are correct. I looked a little closer and they (platzhalter and Rot/Grun) are not separate charts, rather stacked as you indicated. wierd... not sure how it was done.
  22. C

    Combine Column and Stacked Column Chart Both on Primary Axis

    I understand your concern, however these are all different bar charts (ie platzhalter is separate from Ist.. the dark grey one), not one stacked chart. The arrows are a condition based upon rows 41-45 and just add a picture (tip of the arrow). It's a pretty sophisticated use of overlapping...
  23. C

    Combine Column and Stacked Column Chart Both on Primary Axis

    This is not a combined column and stacked column... it is just a column chart. They add data labels (value, inside base) to represent the 'actual?' values. Then, any value from the 'actual' rows that is < or > than the 'plan'has a green/red arrow to show that it is up/down. the...
  24. C

    Match dates in different formats and input amount in correct field

    Assuming that both dates are in structured date fields this should work... if not you will need to first convert one/both to date before doing the compare. Replace the text in [] with your cell references...
  25. C

    Moving Data Table in Chart area

    I haven't found a solution other than your suggestion of creating a separate table. This works great for the example mentioned in this thread, but I will continue to search for a solution. I have a similar situation where I need to tighten the horizontal axis values closer to the axis and this...
Top