MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Help with excel chart

  Asked By: Norma    Date: Oct 17    Category: MS Office    Views: 808

I was wondering if someone could help me with this charting problem:

How can I select data points, let's say by checking the box next to each row, and have excel dynamically put a trendline through just the checked points? Can it be done with or without using VBA macro? I do not want to delete unwanted data to accomplish this; just want to exclude them.



3 Answers Found

Answer #1    Answered By: Della Simpson     Answered On: Oct 17

I think, your charting task can be accomplished without resorting to VBA. Check out the dynamic charting web site of Tushar Mehta and the links provided therein. There are various charting examples available and you should find a model for your task.


Hope this infomation is of some use to you.

Answer #2    Answered By: Devrim Yilmaz     Answered On: Oct 17

Defining a start and end of the range dynamically  is fine but I want
to be able to selectively exclude some points  (outliers) from the
middle so that they are not plotted in the chart  and not considered
in the trendline or estimation of the correlation coefficient.

Can you please help?

Answer #3    Answered By: Ella Brown     Answered On: Oct 17

Charting with VBA in an advanced subject and one that even some of the top
MVPs hate to tackle. With that in mind, here are comments from Excel MVP and
Charting guru, Jon Peltier when I asked him about a similar question some
months ago. Take his advise for what it's work. And you might want to also
check some of his charting articles, particularly his FAQ in TechTrax. His
article link is also below...

Didn't find what you were looking for? Find more on Help with excel chart Or get search suggestion and latest updates.