Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default In charts, is it possible to change data references to relevant?

Ive created a basic bar chart, but the speadsheet in which the data is held
is constantly being updated. This is ruining my graph as the data references
are absolute. Is there a way of changing the source data references to
relevant? ive tried "f4" when in the graph "Source data", "values" option,
but this does not work.
Ive tried deleting all of the $ from the data, but they apear again when the
dialogue box is closed.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default In charts, is it possible to change data references to relevant?

Charts use absolute references. But you can also use a reference to a
dynamic name:

http://peltiertech.com/Excel/Charts/Dynamics.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"* B e X *" <* B e X wrote in message
...
Ive created a basic bar chart, but the speadsheet in which the data is
held
is constantly being updated. This is ruining my graph as the data
references
are absolute. Is there a way of changing the source data references to
relevant? ive tried "f4" when in the graph "Source data", "values"
option,
but this does not work.
Ive tried deleting all of the $ from the data, but they apear again when
the
dialogue box is closed.



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
Variable Names in Source Data References in Charts Teflon TA Charts and Charting in Excel 2 January 21st 07 06:46 AM
Excel references change when importing data jimithing1980 Excel Discussion (Misc queries) 1 July 17th 06 05:02 PM
Auto-increment data source cell references when copying charts Dave Excel Discussion (Misc queries) 2 July 5th 06 07:45 PM
formula references change when data entry sheet is modified ExcelKat Excel Worksheet Functions 0 June 9th 06 12:07 AM
Cell references change when entering new data [email protected] New Users to Excel 2 May 6th 05 07:48 PM


All times are GMT +1. The time now is 10:50 PM.

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

About Us

"It's about Microsoft Excel"