Hi all,

Below this description is a table with the data I'm trying to graph in various ways. It's a project where each client goes through a number of neurofeedback sessions and provides a self-reported score on how they're currently feeling about a problem area (a "Treatment Goal" or TG). So for example, in the first two data rows, Client ID 101, in Session Num 1, reported scores on two TG's: Attention (Score of 8) and Sleep (Score of 6). He had the same pattern of data points through 4 sessions.

Client 102 had three TG's on his first session (session num 1): attention, anxiety, and rumination. But you'll see when we get to his 4th session, he has added an additional TG: Sleep. There may also be some gaps in the data series (e.g., maybe client 101 didn't report a score for one TG for a particular session).

What I'm having trouble doing is getting satisfactory line charts with more than one data series. At this point the data points are ALWAYS going to be from the "Score" field, and the X-Axis labels are ALWAYS going to be "Session Num." What I'd like to be able to do is easily create charts for multiple clients who have the same treatment goal, and charts for one client showing all of their treatment goals. So for example, a line chart showing a line for all clients who have a problem with "Sleep" (each client's scores for Sleep represents one data series). Or I'd like to be able to show all the scores for all treatment goals for one client (so I'd have one chart that shows everything that client 101 is working on, with one line per treatment goal).

I’ve briefly fiddled with Excel PivotTables & PivotCharts, but haven’t gotten very far with it. One immediate problem is that it always seems to want to “Sum” or “Count” or in some way calculate the Score numbers, and I don’t want that. I want to use them as data series in line charts, with no other calculation.

The data is stored in FileMaker Pro 11, which exports easily to Excel. FileMaker has a built-in charting feature and I can pretty easily get a line chart for one client and one treatment goal, but nothing with multiple data series.

Thanks in advance,

...Chuck

Session Num Client ID Score TG Description
1 101 8 Attention
1 101 6 Sleep
2 101 8 Attention
2 101 6 Sleep
3 101 6 Attention
3 101 4 Sleep
4 101 7 Attention
4 101 5 Sleep
1 102 10 Attention
1 102 7 Anxiety
1 102 10 Rumination
2 102 4 Attention
2 102 5 Anxiety
2 102 4 Rumination
3 102 9 Sleep
3 102 5 Anger
3 102 4 Attention
3 102 7 Rumination

---------- Post added at 06:51 PM ---------- Previous post was at 06:49 PM ----------

That table formatting didn't work out very well. There are 4 fields/columns: "Session Num", "Client ID", "Score", and "TG Description".