Chart & Visualization Issues

Fix the Power Pivot Chart “Text String Is Too Long” Error in Excel

Steve KSteve K Nov 22, 2026 868 views

Question details

Resolve a text string length error when creating a Power Pivot line chart with many date and time points.

Fix the Power Pivot Chart “Text String Is Too Long” Error in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Filter the date range

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.

2
Group dates if available

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.

3
Aggregate the source data

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.

4
Refresh and test the chart

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.

Reduce the Number of Date and Time Points
Choose an appropriate aggregation: Use a calculation that suits the data, such as Sum or Average. Aggregating timestamps changes the chart's level of detail.
Free Microsoft Office alternative

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.

Create line charts from spreadsheet dataOpen and edit compatible Microsoft Excel XLS and XLSX filesWork in a familiar spreadsheet interfaceUse a free, lightweight Office alternative
microsoft office alternative - wps office

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.