Hi. I suck at making charts. So sorry in advance for asking what is probably a simple answer.
I have 3 fields of data. Column A, B, C. Column A is year. I would like this data to be the X axis range. So closest to Y axis is 1st year, furthest away from Y is last year.
Column B is number of respondents. I would like this data to be displayed as a Column on my chart.
Column C is $ per respondent. I would like this to overlap as a line, since both line & column show data for the same time frame, which is my X axis.
Any help is much appreciated.
Thank you kindly.
Bookmarks