Hi there!
We are currently working on a project that involves the making of a
scatter/line chart. We will be given a value (call it "Average") that
will be the center of the y-axis for each chart. The x-axis will be the
date that coordinates to each value to be compared to Average. The goal
is to make this chart as automated as possible - another user inputs
data and voila! the chart is made, formatted, etc. The problem: This
Average value will change periodically.
The chart will then have to have a minimum of Average - 0.20 and a
maximum of Average + 0.20, to compare the values from each date.
Additionally, when the value is below or above Average +/- 0.15, there
needs to be some conditional formatting (i.e., the dot turning red).
Is there a way to input the range of the axes in reference to a cell?
Or, is there some way around this?
Any help will be appreciated, Thanks in advance.

Nikki