I have a spreadsheet of Data, with a date column named "DisDate" having information from 1/1/2015 to 4/6/2017 (in mm/dd/yyyy format)
I am trying to build a combo chart where the first column will be a baseline (average of data from 1/1/2015 to 12/31/2015), then the next columns will be the months after MM/YYYY. Each column will be a count of account activity for that month (from a column labeled PatAcc).
I know there are many experts here and I appreciate any help someone can provide.
Rather than do what you are looking to do why don't you either add a seperate reference line to cut across your current years or compare year by year next to each other. would probably visualize in a clearer way and you wouldn't need to do much to achieve the result.