Chitraruveshar
New Member
Hi,
Previously, I use to create many Dashboard files with 1 chart and change the data series of the graph with a range of months dynamically. Then set an offset formula for each X and Y axis.
But the attached file has multiple charts but control the same month. At the moment, I manually increasing the month range in the chart. Does this mean for each chart, as follows
1) I have to set an Offset formula in the Name Manager
2) then set control in the chart to display the monthly to dynamically control the chart by month range?
Wow!! If I were to set formula for each x and y axis, then, it's going to be a long list of name manager.
Please advise or is there a better way to set the formula.
Regards
Chitra
Previously, I use to create many Dashboard files with 1 chart and change the data series of the graph with a range of months dynamically. Then set an offset formula for each X and Y axis.
But the attached file has multiple charts but control the same month. At the moment, I manually increasing the month range in the chart. Does this mean for each chart, as follows
1) I have to set an Offset formula in the Name Manager
2) then set control in the chart to display the monthly to dynamically control the chart by month range?
Wow!! If I were to set formula for each x and y axis, then, it's going to be a long list of name manager.
Please advise or is there a better way to set the formula.
Regards
Chitra
Attachments
Last edited: