Hi,

I'm creating a spreadsheet to track progress over 180 days. I would like to show the change over time with a graph, as shown in the picture below, but I don't want the horizontal axis to encompass all of the cells that have formulas in them. Ideally, the horizontal axis would only extend to the point where the cells contain a numerical value, and after which would stop. The column that the graph is expressing has a formula in every cell, however only expresses a numerical value if there is data for that day, otherwise it expresses "#N/A". I hope I've explained my problem well enough. Basically, I want the horizontal length of the graph to reflect the current amount of data entered, not the entire data column (as some or most of it shows "#N/A")

You'll notice in the picture two graphs. The graph on the top is the graph that includes all the data from column B, which I want, however I only want the horizontal axis to express the value to the highest cell in column B (in this case, B18) which has a numerical value. I want the graph to look like the "Belly %" graph below. However, this graph was created by selecting only B2:B18, which will unfortunately not continue to express future information entered (information on B19 and beyond).

Thanks for all the help and I hope this question isn't too confusing!

Tim

Excel Graph Help.png