I would suggest that you first need to think through exactly what you are trying to illustrate or communicate with the chart. This really isn't specific to Excel, as you would need to address this question no matter what graphing/charting program you are using. We are generally good with Excel, and some of us are good at different aspects of generic charting questions. I am not sure if any of us will be able to give a single solid, authoritative answer to how you should chart these data. If you, too, are already skilled at creating charts and your question is almost exclusively about what kind of chart to create, then I am not sure how much we will be able to help.
I will admit that sometimes I go through a trial and error process of trying different chart types and configurations until I find something that I like. In the spirit of this, I think of 2 possible charts off the top of my head:
1) A line chart (not scatter) where each "AxB" combination is a "category". As with a lot of charting questions in Excel, the big part of creating this chart is about analyzing the source data to summarize the results by "AxB".
In fact, a lot of charting question, it seems, are more about how to arrange the data in the spreadsheet than they are about creating the chart. In other words, once you get the data arranged in the spreadsheet, the chart almost creates itself. Can I assume that you already know how to arrange the data for creating a line chart like this?
2) If I were to use a scatter chart, I would probably go with a "contour" plot. Either A or B is used as the "X values", the other is used for "data series/legend entries", and # of sessions is used for the Y values. This would usually be arranged as a table like:
Then build your chart using column B for the X values and columns D+ as your Y values for each series.
Is that helpful at all?
Bookmarks