Fix the Power Pivot Chart “Text String Is Too Long” Error in Excel
Question details
Resolve a text string length error when creating a Power Pivot line chart with many date and time points.

- Product
- Microsoft Excel Power Pivot
- Device & OS
- not provided
- Scenario
- A user is plotting thousands of date and time points from a Power Pivot data model in a line chart.
- Observed behavior
- Excel displays “The text string you entered is too long,” even though the chart has no unusually long labels. The same data may work in a standard chart.
Check which date and time field is used on the chart axis and whether the chart is based on the Excel Data Model. Identify a smaller date range you can use to test the chart.
Reduce the Number of Date and Time Points
Use a smaller date range or aggregate timestamps when a Power Pivot chart contains thousands of points.
Open the PivotChart's date field filter or its associated PivotTable filter, select a shorter date range, and check whether the chart displays without the error.
In the associated PivotTable, right-click a date value and choose Group. Select a suitable interval, such as Days or Months, if the Group command is available for the field.
If grouping is unavailable, open the source query from Data > Queries & Connections. In Power Query, create a date-only field from the timestamp, then use Home > Group By to summarize values by date or another suitable interval.
Load the aggregated data to the Data Model, select Data > Refresh All, and use the aggregated date field and values in the PivotChart. Expand the date range gradually to see whether the error returns.

Check the Data Model and Reproduce the Chart
Use these checks if reducing the plotted points does not resolve the error.
Create Spreadsheet Charts with WPS Office
WPS Office is a free, lightweight alternative for working with spreadsheets and creating charts in a familiar interface. Its Microsoft Excel format support helps you move compatible files between applications, though it does not fix Excel Power Pivot errors.

Frequently Asked Questions
Why does the error appear when my chart labels are short?
The message can appear in a Power Pivot chart with many date and time points even when labels are not unusually long. Filter the date field to a smaller range to test whether reducing the plotted points helps.
What can I do if the PivotTable Group command is unavailable?
Open the source query from Data > Queries & Connections and use Power Query's Home > Group By command to aggregate the data before loading it to the Data Model.
Where can I find my Excel version and build?
In Excel, open File > Account and look for the version and build under Product Information. Include those details if you contact Microsoft support.
Can WPS Office fix an Excel Power Pivot error?
No. WPS Office is an alternative for working with compatible Excel files and creating spreadsheet charts, but it does not repair Power Pivot errors in Microsoft Excel.




