Search results

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?

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

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

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

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

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

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

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

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

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

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

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!

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

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

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

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

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.

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

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

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"?

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.

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

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

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

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