Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have Yearly Revenue by Region as well as % of Revenue by Region. As I want to show the Yearly Figures I am using the Line Chart . But by using the fast change I want to show the % of Revenue using the Pie Chart .
I mean , I have a line chart showing the Revenue , I want to Fast change it to pie chart to show the % of Revenue .
Is it possible to show two different expressions using Fast Change Charts.
Please help me on this ...
Thanks in Advance ..
Regards,
Chakravarthy
I don't think you can do this with Fast Change because there is no way to detect the current chart type.
As an alternative, you could create two seperate charts and toggle the visibilty using a button that sets a variable.
-Rob
Hi Rob ,
Thanks for your suggestions. As its a client requirement I was just wondering wether I can do it or not . Now i got the clarification on the same .
I have another question to pose to you ...
Can I bring a image in the presentaion tab of the chart ?
The reason why I am asking is due to the space constratints I have developed the legends using text boxes . So when I maximize the chart , unable to show the legends . So if I bring the image in the presentation tab I can use it as a part of the chart . Kindly suggest on the same.....
Thanks in advance ....
Regards,
Chakravarthy.
I don't know of easy any way to do this. You can reposition the text objects using a macro, but I don't know how you would detect the chart maximize event to trigger the macro.
Unless...you disallow maximize and provide your own button that calls a maco that does both the chart Maximize and the text object reposition.
-Rob