drill

Hello, I have a stacked column chart with dates on the x-axis and different codes on the y-axis. I would like to set-up a drill through / drill down function for the codes on the y-axis but I don't know how to do this. For example, one of the stacked column is the code "3xx". This code is...

Hello, if I understand this correctly, Power Pivot is only good if one works with large data. So, I cannot bring data into excel (after I do connection) other than using Power Pivot? If I drill down, will it only bring 1000 lines? If that is the case, what's PowerPivot is good for? Doing just...

Hi, I am stuck on the following problem: I have created a VBA Excel Userform that calculates the max and min hole size for a given bolt size. All calculations etc are contained within the code on the form, I have not and do not want to reference a spreadsheet. I’ve added a Combobox to...

Hi Please do kindly assist me, I would like to know if it is possible to use a single drill down and drill up function to update all the charts in my work book? if so please kindly guide me on how to get this done.

I can't tell whether this is the expected behavior or not, but I am getting more data than I would have expected when I do "show details" or Drill Down from within a Pivot Table. Here is a simple dataset: <colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>#DAE7F5[/URL] "]...

Hi Everyone, I have an excel sheet with a pivot table/slicer that is formatted with a dark border. However, when I use the slicer to drill down the cells that are now empty show no formatting. Is there a way that I can keep the dark border once I drill down? Regards, Dastnai

Hello all! I have a pivot table that has an https address in the raw data, which appears in the drill down results. It looks like: + Supervisor name ....+ Representative name ........+ https:// All this appears in the same column, of course. I've found so many VBA's online that "should" load...

I have dates in column C, like this 2/28/2017 <tbody> And text in column H, </tbody> I want result like this, 0217JIB IDC - DRILL SITE TITLE OPINION Please advise. Thanks

Hi All I have been trying to figure this out for a few days and have given up and hoping you can help. I have a spreadsheet that has a Data table, a Pivot Table and a Dashboard. My users only get to see the Dashboard and the other sheets are hidden. At the moment I have a few slicers that...

Greetings: Perhaps you would direct me as I've search but can't find VBA I need. I have a pivot table with the data tab where I can click on each count and produce the drill down on subsequent tabs. I need VBA which will print all drill down tabs at once. or create all drill down tabs then...

Hi all, I've been scouring around for a solution to my problem and although I've come across similar requests, I have yet to find a concrete answer. My data is in a typical table format, basic columns of data. Some of these data columns are flags (numeric 1's, 0's, or blanks). My pivot table...