Dynamic Range Name For Axis?

R

RayportingMonkey

I am working with a column of numbers that represent ½ hour intervals
(12:00AM, 12:30AM, 01:00AM, etc..., 11:30PM) that run from A11:A58.

This range of data serves as the X Axis for a chart showing performance in
the given interval.

HOWEVER

I must use the same template for multiple vendors and they have different
hours of operations (HOO).

Is there a way to do something like:
IF B2="Vendor1, Vendor4 or Vendor5"
Then let the range A21:A58 be named "HOO"
Else let the range A25:A52 be named "HOO"

OR

Can I use the INDIRECT or VLOOKUP to insert the X Axis range for me?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Range Names? 1
Trying to change x-axis date range 5
Dynamic stacked bar chart not working 3
Excel 2003 dynamic named range for the values in a pie chart 1
Graphic but referencing the values range for Y axis in an externalcell (indirect reference) 1
Second x-axis for line graph 1
Dynamic Range with unused formula messing up x axis on dynamic graph 2
adjust axis range and major units in xy-chart to data series values 0

Top