LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Pivot Chart, changing the range of data weekly

Each week I must add rows of data my worksheet that my pivot chart reads
from. How can I:
A: Get my pivot table/chart to recognize the new range of data without
having to do any formatting changes?
B: I would like to use the "refresh" option, but am don't know much about
this feature. What needs to happen in order to be able to use a "refresh"
button? Do I need to create a macro in order for the Refresh button to work?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Chart Data Data range cannot be changed RobN[_2_] Excel Discussion (Misc queries) 3 April 3rd 23 02:43 PM
Changing a pivot table's data range in Excel 2007 Ken W Excel Worksheet Functions 1 April 1st 07 03:45 PM
pivot chart colors- how to keep from changing when data elements are added/removed? KR Charts and Charting in Excel 1 July 12th 06 06:41 PM
Prevent user changing pivot chart layout Jessica Excel Worksheet Functions 0 April 15th 06 12:24 AM
Maintain colour changes in a Pivot Chart when changing Pivot value rdickfos Charts and Charting in Excel 1 April 11th 06 09:05 AM


All times are GMT +1. The time now is 09:54 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"