8 Replies Latest reply: May 16, 2012 2:49 AM by Soulessfreedom RSS

Dynamic placement of Text in Chart

Soulessfreedom

Hi All, I have some date as my x-axis and I need to group them by their year and use each of the group years as heading of the particular section. I managed to create the text in chart, but as the selection of data changes, the year will not be the same. Hence, I need some solution on how to place the text in the chart dynamically. Below is a picture to show what I have done so far. It is not possible to use 2 level of dimension as I am calculating moving average. (Once i use 2 level of dimension; e.g year and period, the graph will be very funny.) This is quite a hard problem and I cannot find any solution in the discussion forum so far. Hope to hear from you guys soon.

 

Thanks and regards,

soulessfreedom