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

How I can set dynamic pivot table ONLY when I have enough data point 1
How to identify Chart Source data as range? 3
Pivot tables not refreshing after data source update 1
Excel 2007 Pivot Tables - Updated Data Source 1
Pivot Table 2
macro updating imported data and pivot tables 2
Used Range and Source data of a Pivot Table 1
Macro to update pivot table data range 3

Top