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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top