Right Click the Axis and edit the reference line either for Average sale or for 60%, 80% of average. I picked up latter one, but you can change it to first one and still you can achieve the your result.
Then you can change the color pattern it provides for you as below:
So, you can play with it even this box to make other changes as seen in pic. I hope it helps.
follow the below steps
you will get dialogue box, select the required color
based on selected color the final output will be
please find attached workbook for reference
Imtiaz.twbx 1.2 MB
Thank you all. This was extremely helpful. Not only did I learn how to get this to work. I also learned a couple of additional things while following your directions. Thank you to all of you.
1 of 1 people found this helpful
Perfect. Glad to hear it solved your problem. Can you please also mark it as answered so that others can also refer to it if they have the same issue since it solved your problem. Thank you