Dear Mr Excel Community,
I want to add flavor to an existing column chart which displays sales data per region (NY, HK, LND) for each month starting with January until December. In each region, there are several persons contributing to that total number of each column. That is why I want the average across the sales representatives within each region to be displayed in each corresponding column, ideally as a dotted line as shown below in the picture. I have tried several things but not found a solution. I hope my little drawing makes my desire a little clearer. Can somebody help me or give me some good keywords to google for? Let me know if I can provide additional info.
Best,
marinho1
I want to add flavor to an existing column chart which displays sales data per region (NY, HK, LND) for each month starting with January until December. In each region, there are several persons contributing to that total number of each column. That is why I want the average across the sales representatives within each region to be displayed in each corresponding column, ideally as a dotted line as shown below in the picture. I have tried several things but not found a solution. I hope my little drawing makes my desire a little clearer. Can somebody help me or give me some good keywords to google for? Let me know if I can provide additional info.
Best,
marinho1