Hi there
On my spreadsheet I have the dates going along the bottom. What I would like is if there is no value next to the date then for the axis to adjust
ie at the moment I have months in there from Jan 17 to Dec 18, as there are only values in from Jan-Dec 17 at present, I want the axis to reflect that. When I enter a value for Jan 18, then I would like the axis to then readjust to include the extra month.
(Technically they are not empty and displaying a #N/A at the moment to stop it returning a 0 value on the graph)
EDIT :-Or would be even better if it could link to two cells where I can input a date range, and the graph will only show dates in that range)
On my spreadsheet I have the dates going along the bottom. What I would like is if there is no value next to the date then for the axis to adjust
ie at the moment I have months in there from Jan 17 to Dec 18, as there are only values in from Jan-Dec 17 at present, I want the axis to reflect that. When I enter a value for Jan 18, then I would like the axis to then readjust to include the extra month.
(Technically they are not empty and displaying a #N/A at the moment to stop it returning a 0 value on the graph)
EDIT :-Or would be even better if it could link to two cells where I can input a date range, and the graph will only show dates in that range)
Last edited:
