Hello. When trying to create a chart with information trending over a long period of time I keep receiving this error message:myThe maximum number of data points you can use in a data series for a 2-D chart is 32,000. If you want to use more than 32,000 data points, you must create two or more series. Please help.
A corrupt excel spreadsheet can be repaired by using Open and Repair technique. It is a built-in repair function that opens a corrupt excel file forcefully.
*OpenMS Excel >pressCtrl+O >locate corrupt excel spreadsheet and select it.
*Click on the arrow shown besideOpenbutton>selectOpen and Repair.
It will take just a few seconds to be completed and selected file will be opened, if possible.
Or if this doesn't work, one may take help of a third-party
For example Excel Fix Toolbox
https://www.fixtoolbox.com/excelfix.html
Create 2 series,watch your data point use
It is because your excel file is get corrupted. There are several reasons of excel file corruption; virus attack is main reason of corruption. You can fix this problem with the use of "open and repair" utility of MS excel or you can use Excel repair tool http://www.stellarinfo.com/excel-recovery.htm .
337 views
Usually answered in minutes!
×