I have a line graph, which plots two items. One of those items is a "Target" line, but the target needs to change each month (without me going in a moving the line each month).
The graphs work great when there is more than one group returned on the X axis. Unfortunately, my Target line does not appear if only one group is returned on the X Axis.
Graph Configuration: Line Chart, plotting two lines. One of the lines I have formatted the series to display as a Riser.
I have attached my graph configuration, as well as a visual of what I'm trying to do.