 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / August 2006Why does Excel line chart cut off my data series?
This does not happen with other chart forms, including radar. I am trying to create a 3 series chart with data points for each day over a 3 week period. Sometimes get the message that chart can only use 32000 data points, but this is well under that limit. This has not happened before. What is going wrong? (...or what am I doing wrong?) Not a stranger to Excel, though not a power user, but never had this problem before. Will reinstall the program as soon as I find the disk (just moved office). You haven't described what you mean by "cut off". - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ > This does not happen with other chart forms, including radar. I am trying > to [quoted text clipped - 8 lines] > > Will reinstall the program as soon as I find the disk (just moved office). The data series will show up to a certain point, then stops. In this case, it stops at day 12, though there are 21 days of data. The chart is complete in other respects (ie, the x and y axes both extend to the desired values). The data sets will display all 21 days in other chart forms. I hope this is the information you were looking for > You haven't described what you mean by "cut off". > [quoted text clipped - 17 lines] > > > > Will reinstall the program as soon as I find the disk (just moved office). Go to Source Data on the Chart menu. Click on the Series tab. Select the "cut off" series. Are the complete ranges shown in the X values and Y values boxes? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ > The data series will show up to a certain point, then stops. In this > case, [quoted text clipped - 31 lines] >> > Will reinstall the program as soon as I find the disk (just moved >> > office). I am assuming you mean value ranges. Yes. This was one of the first things I checked. Also checked data range. Still getting message that 2D charts are limited to 32000 data points. Am nowhere close to that! I have tried recreating chart several times with similar results. BAffled. > Go to Source Data on the Chart menu. Click on the Series tab. Select the > "cut off" series. Are the complete ranges shown in the X values and Y values [quoted text clipped - 42 lines] > >> > Will reinstall the program as soon as I find the disk (just moved > >> > office). |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.