M
Manos
I would like to set X-Values in my chart in a cell of a worksheet, so that
when the range of my x-values changes I will not have to go into the wizard
and type it again.
For example, I want to use the following X-values in my chart:
=DATA!$I$2:$I$20
But instead of typing the above in the X Values: field in the 'Source Data /
Series' wizard, I would like to type it, say, in cell $A$1 of 'Sheet1', and
then type in the X Values field in the 'Source Data / Series' wizard the
following:
=Sheet1!$A$1
I tried it and it does not work. Can you please let me know if there is a
way to achieve what I am trying to do?
Thanks.
when the range of my x-values changes I will not have to go into the wizard
and type it again.
For example, I want to use the following X-values in my chart:
=DATA!$I$2:$I$20
But instead of typing the above in the X Values: field in the 'Source Data /
Series' wizard, I would like to type it, say, in cell $A$1 of 'Sheet1', and
then type in the X Values field in the 'Source Data / Series' wizard the
following:
=Sheet1!$A$1
I tried it and it does not work. Can you please let me know if there is a
way to achieve what I am trying to do?
Thanks.