| 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. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Can chart size be dynamically adjustable to fit data points?
Hi,
You need to create a named range rather than trying to use formula in the series reference box. See here for more detail http://peltiertech.com/Excel/Charts/Dynamics.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Mitch" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Can chart size be dynamically adjustable to fit data points?
Thanks Andy. What I have reviewed so far comes close to what I need.
Mitch "Andy Pope" wrote: Hi, You need to create a named range rather than trying to use formula in the series reference box. See here for more detail http://peltiertech.com/Excel/Charts/Dynamics.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Mitch" wrote in message ... 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. |
| Reply |
| 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) | |||
Linear Mode
