Hey all,
This seems so elementary to me, but I can't for the life of me figure it out in Excel 2013. I have a chart that is organized like the below:
Date Patient Name PCP PCP City Referred By Orders
date 1 Patient 1 PCP 1 PCP City 1 Referrer 1 Product 1
date 2 Patient 2 PCP 2 PCP City 2 Referrer 2 Product 2
I'm simply trying to build a bar chart that is organized so that the y-axis is "count of patients", x-axis is "month" from 2013-2015, and each bar is an individual PCP so i can see the new patient referral trends by month by PCP, compare them against each other, etc. I'm unsure how the select data function works under chart tools. I'm using Excel 2013. I'd greatly appreciate the help, as I can apply the methodology to several other tables I need to build.
Thanks!
Captain
Bookmarks