A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Trendline when data points are missing



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old May 11th, 2010, 06:16 PM posted to microsoft.public.excel.charting
Chris Moran
external usenet poster
 
Posts: 1
Default Trendline when data points are missing

I have data where for some of the series there is data in each "category" and
in other series there is some missing data. Here's the example:

Fund Type Fund Company One Year Return
Target 2050 Principle 12.2
Target 2050 TRP 11.3
Target 2045 Principle 11.1
Target 2040 Principle 10.8
Target 2040 TRP 9.4

When I chart this I get a line for all of the "Principle" data because it
has a data point for all three "Fund Types". I only get data points and no
line for "TRP" because it has no data point for the "Target 2045" "Fund
Type".

I would like to add a trend line that simply "connects the dots", but none
of the available trendlines will do that. I also can't put a formula in the
cells because the source data is a pivot table. Any solutions for this?
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:10 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.