Hoping someone can help with this. I am displaying sales data by month on a bar chart. I would like to add a reference line that varies by month. So, instead of one constant line for the entire year, I need to program a certain value for January, a certain value for February, etc. so that the reference line will fluctuate throughout the course of the year. Any suggestions?
This can be done if Month is discrete. When you add the reference line select Per Cell at the top of the dialogue. Hope this helps!