 |
 | 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 / September 2006Trendline Not Always Available
In a workbook with multiple charts on multiple spreadsheets, the chart option to add a trendline is available on some of the charts and not on others - why? (I have tried right clicking on the series - that is not the problem). The data on the underlying spreadsheet appears to be entered and formatted the same way. Of course, I have tried clicking on both axes, clicking on the chart, off the chart, on the series line, on the series label in the legend and so on. Yet, on other spreadsheets the feature works fine. I have tried this on two PCs, with the same document (and the same errors) - in other words, I doubt if re-booting will fix it either. 3d charts do not allow trendlines maybe this is your problem Cheers Andy > In a workbook with multiple charts on multiple spreadsheets, the chart option > to add a trendline is available on some of the charts and not on others - [quoted text clipped - 5 lines] > this on two PCs, with the same document (and the same errors) - in other > words, I doubt if re-booting will fix it either.  SignatureAndy Pope, Microsoft MVP - Excel http://www.andypope.info Andy: Thank you. Actually, I blundered onto the answer. It is the chart type selection. In the menu of line chart types, the line chart on the far lef-hand side of the box (with bumps) will accept a trendline. The next chart option to the right (in the center of the selection box), which appears to be identical (at least to me), will NOT accept a trendline. Go figure! > 3d charts do not allow trendlines maybe this is your problem > [quoted text clipped - 10 lines] > > this on two PCs, with the same document (and the same errors) - in other > > words, I doubt if re-booting will fix it either. Ah yes, as well as 3d charts STACKED charts can not have trend lines. Cheers Andy > Andy: Thank you. Actually, I blundered onto the answer. It is the chart > type selection. In the menu of line chart types, the line chart on the far [quoted text clipped - 16 lines] >>>this on two PCs, with the same document (and the same errors) - in other >>>words, I doubt if re-booting will fix it either. SignatureAndy Pope, Microsoft MVP - Excel http://www.andypope.info |
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.