OFFSET for multiple columns & combobox format
 

Is there a way to have an OFFSET range of two columns? I have been using
multiple columns for my X axis values with non-dynamic charts. Now i'm
designing a dynamic chart, but Excel will not let me select two columns
(month/wk) for my X axis.
Another simple question how can I format a comboBox text in a chart?

Thanks.
--
when u change the way u look @ things, the things u look at change.

OFFSET for multiple columns & combobox format
 

To create an offset for multiple columns, first define a range name that
makes up those columns. For example, the name "XAxisCol" covers columns A
and B and refers to the formula / range:

=Sheet1!$A$1:$B$1

Then create a second range name which will be the source for your X axis in
your dynamic chart. For example, name this formula "XAxis".

=OFFSET(XAxisCol,Sheet1!$D$1,0,1)

--
John Mansfield
http://cellmatrix.net





"sahafi" wrote:

Is there a way to have an OFFSET range of two columns? I have been using
multiple columns for my X axis values with non-dynamic charts. Now i'm
designing a dynamic chart, but Excel will not let me select two columns
(month/wk) for my X axis.
Another simple question how can I format a comboBox text in a chart?

Thanks.
--
when u change the way u look @ things, the things u look at change.

OFFSET for multiple columns & combobox format
 

Thanks John. I will give it a try.
--
when u change the way u look @ things, the things u look at change.


"John Mansfield" wrote:

To create an offset for multiple columns, first define a range name that
makes up those columns. For example, the name "XAxisCol" covers columns A
and B and refers to the formula / range:

=Sheet1!$A$1:$B$1

Then create a second range name which will be the source for your X axis in
your dynamic chart. For example, name this formula "XAxis".

=OFFSET(XAxisCol,Sheet1!$D$1,0,1)

--
John Mansfield
http://cellmatrix.net





"sahafi" wrote:

Is there a way to have an OFFSET range of two columns? I have been using
multiple columns for my X axis values with non-dynamic charts. Now i'm
designing a dynamic chart, but Excel will not let me select two columns
(month/wk) for my X axis.
Another simple question how can I format a comboBox text in a chart?

Thanks.
--
when u change the way u look @ things, the things u look at change.