I have a model that shows the current calls on our switches. It's presented as a bar graph.
I want to present on the chart as text two values: the current value, and last weeks value, but I don't want last week's value to be a separate bar on the chart.
So far what I came up with is to use a combo chart, and present the other value as a Symbol. It looks nice, but when I choose "Values on data points", the text of both values overlap.
I could use the "Plot values inside Segments" option, but my boss doesn't like it [:P]
Anyone got an idea how to -
a. Present a text lable with a different value (so I can just present the last weeks value instead of this weeks) or -