data source range

  1. C

    Pie Chart & Graph - dynamic data source

    Hi all I have a workbook, with a worksheet for each month which contains a table in which daily figures are input. Next to this, I have another worksheet with reports of various pie charts and graphs to illustrate where the work time has been spent, enquiry origin etc etc. which are created...
  2. K

    Creating Pivot Tables from Multiple Worksheets

    Hi, I was hoping to create a pivot table from multiple worksheets that consist of multiple tabs. I am finding that I have too many elements within my data source to do this. Is there a solution other than making the world's largest master worksheet? Please advise. My elements are: Year...
  3. N

    Macro: Change chart source data without using Activate

    I'm trying to create a macro that changes the source data from specific cells for different cases. The button to run the macro is in Sheet1 and the charts are in Sheet2. My code so far is: Sheets("Sheet2").ChartObjects("Chart 1").Activate ActiveChart.SetSourceData...
  4. L

    Pivot table-change data source

    I built a pivot table in Workbook 1, then a new version was created. So I copied the pivot table to Workbook 2. But now the data source for the table is still in Workbook 1. The data is basically the same in both workbooks except that workbook 2 is the one that I will be editing and adding...
  5. B

    Changing the data source range for a PivotTable

    Hi. I use PivotTables to sum and analyse client's bank account details, basically a list of payments. Pre-Excel 2007, I could amend the size of the data range of a pivottable to take into account the extra or fewer transactions in this year over last year by (I think) right-clicking the...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top