| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can chart size be dynamically adjustable to fit data points?
I am multiple series of data of varying lengths and would like to enter the
number of data points in a cell and have the corresponding chart be dynamically adjusted to fit the current data sample. I tried specifying the series values as follows: =Sheet1!$B$6:INDIRECT(<cell holding the reference of the cell calculated to hold the final data point,1). It says there is an error in the formula but when I click OK it highlights the exact range that I am trying to use. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change point size of all points in an xy chart | Charts and Charting in Excel | |||
| Chart adjustable range | Charts and Charting in Excel | |||
| Dynamically change data in chart title | Charts and Charting in Excel | |||
| Scatter plot - Size of data points from spreadsheet value? | Charts and Charting in Excel | |||
| Dynamically changing the size of a list | Excel Discussion (Misc queries) | |||
Threaded Mode
