If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|