Is it possible to take this data:
...And display it in a single line chart and have the B series "connected" with lines the way series A connects? The missing data in 1920 and 1998 causes the connection lines to disappear on the second data set.
A B 1866 10 200 1920 20 1974 30 350 1998 50 2005 10 500
Possible at all? See the attached sheet, I'd like the "B" lines connected in the first chart the way they are in the second chart (separate).
Last edited by JBeaucaire; 01-03-2011 at 04:29 AM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hi Jerry,
Have you tried adding a "trendline" for that series of data? You should be able to overwrite/hide the original data, and get the trendline to appear as the original.
Note - Polynomial (Order = 6) works okay.
Cheers,
Last edited by ConneXionLost; 01-03-2011 at 01:48 AM.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Select the chart and use
Tools > Options > Chart > Plot empty cells > Interpolate
Awesome! Thanks, Andy!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks