#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 347
Default pivot chart

I would like a pivot chart to not display the new data (as chart)
automatically immediately as you refresh the table new data entry receiving
the data but gives us the opportunity when we want to choose to appear them
in the chart.
Not automatically bur manually to been seen (if we choose them)
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,722
Default pivot chart

Don't refresh (or auto-refresh on open) the Pivot Table/Chart then until you
want the new data displayed. If its a matter of adding a new series, you
should be able to select only the series that you want to display from the
dropdown.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"george" wrote:

I would like a pivot chart to not display the new data (as chart)
automatically immediately as you refresh the table new data entry receiving
the data but gives us the opportunity when we want to choose to appear them
in the chart.
Not automatically bur manually to been seen (if we choose them)

Reply
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
Duplicating Pivot Chart / Changing Pivot Chart data range BillG Excel Discussion (Misc queries) 4 February 25th 10 02:15 PM
Pivot Chart Created from Pivot Table is Blank RaidersFan Charts and Charting in Excel 1 January 25th 09 10:34 PM
How to create chart from Pivot table but not Pivot chart? Daniel Charts and Charting in Excel 1 July 31st 07 01:32 AM
When refreshing pivot tables my pivot table chart type changes hannah220507 Excel Discussion (Misc queries) 1 May 22nd 07 02:57 PM
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 06:01 PM.

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"