Problem: I have a group footer "State" in which for each state I have a pie chart. I need each State to show up in either the title or subtitle of my chart. For example, each chart should show "Florida" or "Georgia".
Note: If I was going to simply use these charts in Crystal, I would create a text box above the chart and call it a day.
Solution needed: But I am exporting each of these charts into Excel spreadsheets for reports sent out to managers of each state (they want it in excel and not pdf so they can manipulate it).
Crystal sometimes automatically puts in a changeable title, according to the group footer, but I don't know how it does it and why. I have not been able to recreate it and it is frustrating. I have read Business Objects white papers and I cannot find the solution.
Please help!!!!
Note: If I was going to simply use these charts in Crystal, I would create a text box above the chart and call it a day.
Solution needed: But I am exporting each of these charts into Excel spreadsheets for reports sent out to managers of each state (they want it in excel and not pdf so they can manipulate it).
Crystal sometimes automatically puts in a changeable title, according to the group footer, but I don't know how it does it and why. I have not been able to recreate it and it is frustrating. I have read Business Objects white papers and I cannot find the solution.
Please help!!!!