My chart won't show all of the data I selected

If you select a column as a data series for your chart and it has more than data points, only the first 365 values will display in the chart. This limit helps the chart load more quickly and be more readable.


If you need to display more than one year's worth of data, you will need to group it in some way (by week or month) or use the data in two different charts.

Another way to display all of the data would be to split it up by year through a pivot chart or SQL. Then you can chart each year as a separate line or column to get it all into one chart. But keep in mind that it still might be more useful to group the dates in some way or pick a small date range to display to keep the chart readable and useful.


Was this article helpful?