Is it possible to create the red (hand drawn) line on a pivot chart?
I have a time series of data that I chart but I want to add a horizontal line with the most recent value, similar to the pic. And I obviously want it to update as new dates are added.
I haven't been able to figure out how unless I summarize the values in the source data.
I have a time series of data that I chart but I want to add a horizontal line with the most recent value, similar to the pic. And I obviously want it to update as new dates are added.
I haven't been able to figure out how unless I summarize the values in the source data.