Forum Discussion
Change Date Range for Chart
I feel like this is an easy fix, but it is driving me crazy. I downloaded a template from Xelplus and I can't figure out how to change the date range on the chart. It is populating from 2016 through ...
BradleyD590 Right-click on the Horizontal (Value) Axis (on any one of the dates shown at the top of the chart) and select "Format Axis...". Then, in the Format Axis pane, under Axis Options > Bounds, click the button to "Reset" the minimum (lower) bound date. You can also manually set the min/max bounds and major/minor units, if desired.
Format Chart Axis