| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
link a chart source to a cell reference
Hi, lets say i have a cell A1 that shows the text B1:B5, and i have a cell A2
that shows the text C1:C5. Then i want to have a chart that references cells A1 and A2, and hence knows that i want it to chart the data in arrage B1 to C5 (an x-y scatter plot). the point being the text values in cells A1 and A2 might change, and i want to the chart to automatically update and plot the new ranges specified. i can't work out how to do this. is it possible? thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel changes chart source data. Drops the Filename reference from | Excel Discussion (Misc queries) | |||
| Auto update chart source reference | Charts and Charting in Excel | |||
| How do you link chart source data when you copy the chart? | Charts and Charting in Excel | |||
| Can Excel 2003 cell link carry with it the source cell format? | Excel Discussion (Misc queries) | |||
| Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Threaded Mode
