Hi everyone,
I currently have a ton of names defined as a range of "offset" that chart the newest data on a graph and it works great. The only issue is that the last dates are different for each series and they do no change at a constant speed.
For example, I have Monthly sales, updated every 1st of the month, the last number there would be the tally for August. But I also have expenses, updated the 15th of the month, the last number being July.
The graph for August is defined by names (last 12 months in data is a name) and last 12 months of months is the x-axis.
However there is a time where I would have to change the name defined in the chart so that they can all be updated as far as the x-axis is concerned. With two graphs this would be easy but I actually have about 80 interlapping charts each at it's own time scale.
Basically what i'm asking is: Is there a way (or a workaround) to tell the graph to choose a certain name to graph on the x-axis depending on the position of the last number in the data (or depending on any other parameter I could choose).
Thank you for your help.
I currently have a ton of names defined as a range of "offset" that chart the newest data on a graph and it works great. The only issue is that the last dates are different for each series and they do no change at a constant speed.
For example, I have Monthly sales, updated every 1st of the month, the last number there would be the tally for August. But I also have expenses, updated the 15th of the month, the last number being July.
The graph for August is defined by names (last 12 months in data is a name) and last 12 months of months is the x-axis.
However there is a time where I would have to change the name defined in the chart so that they can all be updated as far as the x-axis is concerned. With two graphs this would be easy but I actually have about 80 interlapping charts each at it's own time scale.
Basically what i'm asking is: Is there a way (or a workaround) to tell the graph to choose a certain name to graph on the x-axis depending on the position of the last number in the data (or depending on any other parameter I could choose).
Thank you for your help.