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 In copied worksheet, embedded chart uses data fm orig - change?

When I copy a worksheet, I want the embedded chart to automatically use data
from the new worksheet, Instead, it uses data from the original worksheet.
So I have to edit each data series in the chart everytime I create a new
worksheet by copying an old one.
Example: worksheet displaying hours worked that week. When I copy the sheet
to start a new week, the embedded chart is displaying data from last week.
 
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
Can I use data from different worksheets to create a chart Dona Charts and Charting in Excel 2 March 14th 06 01:47 AM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
Excel 2002 chart does not update when worksheet data changes proquant Charts and Charting in Excel 1 June 15th 05 12:23 AM
Macro to search for and display data in another worksheet Mark H Excel Worksheet Functions 0 June 14th 05 12:40 PM
How can I show data under a Chart that I inserted in a worksheet? Kimo Charts and Charting in Excel 1 February 21st 05 04:11 PM


All times are GMT +1. The time now is 01:47 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"