Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display different charts
Hi,
I'm not sure if what I'd like to do is possible, but hopefully someone will be able to help me out. I have an Excell 2003 workbook which contains various sheets. On one sheet I have 3 charts that are derived from data in the other sheets. I would like to give the user viewing the charts the option of viewing chart1, chart2 or chart3 individually, or, if required, all at once. I would like to do this with a drop down selction box that has the options chart1, chart2, chart3 and Show All. If chart1 was selected then the others would be hidden and so on. Is this possible? Thanks for any help. Gary. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display different charts
Try these examples:
http://peltiertech.com/Excel/Charts/...eDropDown.html http://peltiertech.com/Excel/Charts/ChartByControl.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Gary" wrote in message ups.com... Hi, I'm not sure if what I'd like to do is possible, but hopefully someone will be able to help me out. I have an Excell 2003 workbook which contains various sheets. On one sheet I have 3 charts that are derived from data in the other sheets. I would like to give the user viewing the charts the option of viewing chart1, chart2 or chart3 individually, or, if required, all at once. I would like to do this with a drop down selction box that has the options chart1, chart2, chart3 and Show All. If chart1 was selected then the others would be hidden and so on. Is this possible? Thanks for any help. Gary. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display different charts
Hi, thanks for your quick reply.
I don't really know much about all this and I'm not sure what's going on from the downloaded example. It is the second worksheet functionality I need. Why are there two list boxes for the user to pick from? And where is the code assigned to? Thanks. Jon Peltier wrote: Try these examples: http://peltiertech.com/Excel/Charts/...eDropDown.html http://peltiertech.com/Excel/Charts/ChartByControl.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Gary" wrote in message ups.com... Hi, I'm not sure if what I'd like to do is possible, but hopefully someone will be able to help me out. I have an Excell 2003 workbook which contains various sheets. On one sheet I have 3 charts that are derived from data in the other sheets. I would like to give the user viewing the charts the option of viewing chart1, chart2 or chart3 individually, or, if required, all at once. I would like to do this with a drop down selction box that has the options chart1, chart2, chart3 and Show All. If chart1 was selected then the others would be hidden and so on. Is this possible? Thanks for any help. Gary. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display different charts
There are two types of listboxes, one from the Forms toolbar, the other from
the Controls Toolbox. They work similarly, and each has advantages. Changing the controls toolbox listbox changes the value of cell A14 (named CtrlTbxLink2) so it shows the selected value in the listbox. You can see this if you show the Visual Basic toolbar, enter design mode (click on the icon with the triangle and T-square) right click on the listbox, and choose Properties. The name or address of the linked cell is shown in the LinkedCell property. When this listbox is changed, it runs the ListBox1_Change sub located on the Sheet2 code module (right click on the Drop Down Chart 2 tab and choose View Code). Changing the forms toolbar listbox changes the value of cell A21 (named FrmTbrLink2), so it shows the index of the selected value. Right click on the listbox and choose Format Control, click on the Control tab, and the Cell Link box shows the name or address of the linked cell. Right click on the listbox and choose Assign Macro to see which procedure runs when the listbox is clicked. Click the Edit button in this dialog to see the procedure. In my code I've linked the two controls together, so they both always show which chart is activated. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Gary" wrote in message ups.com... Hi, thanks for your quick reply. I don't really know much about all this and I'm not sure what's going on from the downloaded example. It is the second worksheet functionality I need. Why are there two list boxes for the user to pick from? And where is the code assigned to? Thanks. Jon Peltier wrote: Try these examples: http://peltiertech.com/Excel/Charts/...eDropDown.html http://peltiertech.com/Excel/Charts/ChartByControl.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Gary" wrote in message ups.com... Hi, I'm not sure if what I'd like to do is possible, but hopefully someone will be able to help me out. I have an Excell 2003 workbook which contains various sheets. On one sheet I have 3 charts that are derived from data in the other sheets. I would like to give the user viewing the charts the option of viewing chart1, chart2 or chart3 individually, or, if required, all at once. I would like to do this with a drop down selction box that has the options chart1, chart2, chart3 and Show All. If chart1 was selected then the others would be hidden and so on. Is this possible? Thanks for any help. Gary. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display different charts
Thanks a lot. Very helpful.
Jon Peltier wrote: There are two types of listboxes, one from the Forms toolbar, the other from the Controls Toolbox. They work similarly, and each has advantages. Changing the controls toolbox listbox changes the value of cell A14 (named CtrlTbxLink2) so it shows the selected value in the listbox. You can see this if you show the Visual Basic toolbar, enter design mode (click on the icon with the triangle and T-square) right click on the listbox, and choose Properties. The name or address of the linked cell is shown in the LinkedCell property. When this listbox is changed, it runs the ListBox1_Change sub located on the Sheet2 code module (right click on the Drop Down Chart 2 tab and choose View Code). Changing the forms toolbar listbox changes the value of cell A21 (named FrmTbrLink2), so it shows the index of the selected value. Right click on the listbox and choose Format Control, click on the Control tab, and the Cell Link box shows the name or address of the linked cell. Right click on the listbox and choose Assign Macro to see which procedure runs when the listbox is clicked. Click the Edit button in this dialog to see the procedure. In my code I've linked the two controls together, so they both always show which chart is activated. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Gary" wrote in message ups.com... Hi, thanks for your quick reply. I don't really know much about all this and I'm not sure what's going on from the downloaded example. It is the second worksheet functionality I need. Why are there two list boxes for the user to pick from? And where is the code assigned to? Thanks. Jon Peltier wrote: Try these examples: http://peltiertech.com/Excel/Charts/...eDropDown.html http://peltiertech.com/Excel/Charts/ChartByControl.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Gary" wrote in message ups.com... Hi, I'm not sure if what I'd like to do is possible, but hopefully someone will be able to help me out. I have an Excell 2003 workbook which contains various sheets. On one sheet I have 3 charts that are derived from data in the other sheets. I would like to give the user viewing the charts the option of viewing chart1, chart2 or chart3 individually, or, if required, all at once. I would like to do this with a drop down selction box that has the options chart1, chart2, chart3 and Show All. If chart1 was selected then the others would be hidden and so on. Is this possible? Thanks for any help. Gary. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP! selection box to display charts | Excel Worksheet Functions | |||
Better display of my pie charts | Charts and Charting in Excel | |||
Charts will not display!! | Excel Discussion (Misc queries) | |||
Is it possible to display text in charts? | Charts and Charting in Excel | |||
Don't won't charts to display Zeroes | Charts and Charting in Excel |