I have a data series over a period of months. I am graphing it using a line graph. I have created 3 additional "dummy" columns to graph the average and +1 and -1 standard deviations.
I would like to put a labels to the right outside the graph lines labeling "avg", "SD+1" and "SD-1". I have put these as my titles to the appropriate column but when I - Format Data Series - and then add the series name - it appears for every data point. How can I put this labels on properly so that they appear only once to the right and so that they change as the data changes?
I would like to put a labels to the right outside the graph lines labeling "avg", "SD+1" and "SD-1". I have put these as my titles to the appropriate column but when I - Format Data Series - and then add the series name - it appears for every data point. How can I put this labels on properly so that they appear only once to the right and so that they change as the data changes?