• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Flexible charts - Urgent

arlu1201

New Member
I have a dropdown which has these options - Group Total, Group Breakup, Member1, Member2, Member3. As you select options in the dropdown, the corresponding data will change. This works fine. Now, my problem begins here. I also have some charts which will change based on the data that is there. If i select group total, only 1 chart showing the values should be seen on the page. If i select group breakup, then i want individual charts to appear for each member in the group. If i select member1, then only 1 chart should appear showing member1's values. How can i do this without VBA? Please help. This is urgent.
 
Arlu

I would have a browse through

http://chandoo.org/wp/2009/05/19/dynamic-charts-in-excel/


or probably this page


http://chandoo.org/wp/2008/11/05/select-show-one-chart-from-many/
 
Thanks for your reply. I checked both the links above. The charts are flexible but just 1 at a time is visible. How can I make 4 visible at one time and then when i change the dropdown, only 1 should be visible?
 
Arlu

I haven't tried this but it should work?

Setup the charts as in

http://chandoo.org/wp/2008/11/05/select-show-one-chart-from-many/

Re-arrange the charts that you want grouped

use a Camera Tool to take a picture of the combined area

Rescale the Camera Tool as appropriate

Name the Camera Tool

Include the Nmaed Camera Tool in the list of Charts as described above
 
You can find camera tool from excel options > customize > buttons not in ribbon. Here is a tutorial.


On a side note, pls. never title your posts as "urgent". It may be urgent to you, but not for rest of the members here. http://chandoo.org/wp/2008/12/02/excel-camera-tool-help/
 
Sorry about that. I usually do that to have people reply to me faster..:) I will try and see if your solution works. Thanks for your prompt reply.
 
Back
Top