Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable Names in Source Data References in Charts | Charts and Charting in Excel | |||
Excel references change when importing data | Excel Discussion (Misc queries) | |||
Auto-increment data source cell references when copying charts | Excel Discussion (Misc queries) | |||
formula references change when data entry sheet is modified | Excel Worksheet Functions | |||
Cell references change when entering new data | New Users to Excel |