Apply a filter to a chart?

[brucemc777]

Well, that probably accurately expresses what I need to do, but I think that is about as good as I get. I might use the filter as a selection from a combobox, or I might honestly wish to create 15 separate charts.

I have a spreadsheet. Three columns out of maybe six in immediate interest: Date, Name and score.

In "name" I have about 15 different students. I wish to create a chart that will extract the data for one of them which I would select - on the vertical ("y") axis have the scores (from "score") which range in whole numbers from 1 to 9, and on the horizontal ("x") axis show the dates (from "Date") of each score.

Complicating my thinking is the fact that a date can have more than one score, but seldom more than three.

I would then want to add a trend line through the graph, which, if I recall, is fairly easy to do.

I am wondering if I might at some point need to control the length of history, for though now I am working with about three months and over that period of time no one has more than 18 total scores, it might at some point get congested.

I am just as appreciative if you shove me to a good resource that describes this along with other charting education as I need to get back up to speed!

Thank-you,
Bruce

P.S.: I am not with extra funds by any means, but I would like when able to contribute a few dollars here and there as a show of appreciation to this board - not to expedite answers, but to help in my own little way support and say "Thank-You". As I don't want to have any contribution be tied to expediting answers, how should I go about this?

[nathansav]

Pivot Chart?

[nathansav]

Attached a bit of a convoluted way of doing using pivots. There is a bit of VBA code also.

[brucemc777]

I had considered using pivots but I wanted a means to create each individually - having a hard time describing why, maybe as I was thinking of creating and having all charts up at the same time; having up to 15 pivot tables running contemporaneously seemed a bit much.