Hi - I have a bunch of line and stacked column charts where I need to show a title, whcih is based on the value of a table field. This field is being used as filter - so, as an example, if this field is set say Location A, I want to use that field in the title of the chart. When I try to set that using the fx button on the title property, I can see the column in the drop down (on conditional formatting dialog), however, it does not keep/select the value. the OK button is diabled and there are no warnings or error messages.
How can i get that field to bein included in my chart as a title. I have pages of charts for 8 locaitons and so need to be able to set it to be dynamic.
When i use that field as a Column legend, then the Month To Date line for the secondary Y axis condenses to only available values. So, as of today, it will only show 10/11 column and cumulative line on the secondaty Y axis for MTD. WHen I remove the legend, all days of the month appear with 10/11 columns and a MTD line, flat from today to the rest of the month. So, the point I'm making here is the legend cannot be used, as the users want to see the entore month (days in the future).
Hope this makes sense and someone has had a similar situation before.
Any suggestions on what I may be doing wrong would be very helpful.
Thanks for your help.
RK
