I'm trying to create a line graph that uses a formula for the Y-axis, and where the X-axis is based on time. The variable for which I want the formula to graph along is time, a value that I enter
I can't figure out how to get the graph to show the formula as it changes over time.
For example, I have a single cell (A) that gives my output data. It changes depending on a signle input I give it from another cell (B). How do I get a graph to show what cell A outputs, as B changes?
You have to construct a set of data for the chart to plot. It will not just plot a formula.
Either create a set of data points using the formula and varying input
or try a named formula, which can calculate your values.
Check Stephen Bullen's ChtFrmla example
http://www.oaltd.co.uk/Excel/Default.htm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks