Excel 2007-Pivot Chart Expensding data source

L

Lee Mendelson

Hi,
I would like to epxand the data source of my pivot table.
For example,I have data on Jan09 and I created a Pivot, now I wouls like to
add Feb09 data as well, the db was added, howver I have no Idea how I refresh
the pivot on a larger data range, in order to See jan and Feb as well.

Please assit,
Thanks,Lee.
 
J

Jacob Skaria

Hi Lee

From Menu->'PivotTable Tools' select 'Change Data Source'. Choose the Feb
data holding the Control key. This will select multiple ranges.

Jacob
(If this post helps please hit Yes)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
How I can set dynamic pivot table ONLY when I have enough data point 1
Changing pivot table ADO recordset 0
Change SourceName on Pivot Table 0
Pivot tables not refreshing after data source update 1
How to identify Chart Source data as range? 4
Macro to update pivot table data range 3
Please help! Cannot open pivotTable source file.... 2

Top