| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change source according to data entered in a template.
I am using third party software to enter data into a template. Things seem
to work fine, except I want to vary the source data for the chart in the template according to how many rows of data have been entered from the third party. Is there a way to do this?? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Change source according to data entered in a template.
try using a defined name for the source data
editnamedefinemysourcerangerefers to =offset($a$2,0,0,counta($A:$A),6) -- Don Guillett SalesAid Software "ANStech" wrote in message ... I am using third party software to enter data into a template. Things seem to work fine, except I want to vary the source data for the chart in the template according to how many rows of data have been entered from the third party. Is there a way to do this?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't change source data path for Pivot Chart | Charts and Charting in Excel | |||
| Setting hover data labels to cells other than source data | Charts and Charting in Excel | |||
| Setting hover data labels to cells other than source data | Excel Discussion (Misc queries) | |||
| Create template that ignors data list rules | New Users to Excel | |||
| How do I change data that has been entered in a column to a row? | Excel Discussion (Misc queries) | |||
Linear Mode
