PDA

View Full Version : Display Charts



cavemonkey
04-24-2008, 08:00 PM
Hi

I have a spreadsheet that has many charts and its rather messy. I'm thinking of combining all the charts into just one representative chart whereby there's a dropdown bar to select which chart you want to view and that particular chart will display your choice. Is it possible? Please help

Thank you

lucas
04-24-2008, 09:35 PM
This might be just what you are looking for. It works great and easy to set up.
http://www.j-walk.com/ss/excel/tips/tip66.htm

Bob Phillips
04-25-2008, 12:22 AM
I did this a few months back in this thread http://www.vbaexpress.com/forum/showthread.php?t=17365&highlight=muliple+%2B+charts+%2B+paste

It uses buttons not a dropdown, but it has an example workbook and could be easily adapted.

cavemonkey
04-25-2008, 12:40 AM
This might be just what you are looking for. It works great and easy to set up.
http://www.j-walk.com/ss/excel/tips/tip66.htm

This is ok but it does not give you the freedom to select and display any charts that you want. So for me this is not what I want. But thanks anyway

Bob Phillips
04-25-2008, 01:02 AM
Check my reply.