OFFSET for multiple columns & combobox format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
Back
Top