I'm working on a simple chart that displays seasonal average prices for an index. My dimension is a date field and expression is an average of bid and offer values. I would like to have a reference line on a chart to show when each ear starts.
For example, attached is the sample app with charts that I would like to have. The only addition that I would like to make to the chart is have a vertical reference line showing up on January 3, 2017, January 4, 2016, January 1, 2015 etc.
Does anyone know of a way to get that reference line on the chart?
... tick the Values On Data Points option and set labels to display vertically (on the Presentation tab). It will only display when there's a reduced number of data points but it might work for you. Bit of a hack, though. And I haven't tested it through Accesspoint either.
I'd also look at options such as setting the line color and line styles to alternate between periods. Also, you could change to a combo chart and have an alternating background color (essentially a static bar value which changes to alternating shades at the require date points - just set the Bar and Cluster distances to zeroes).