Charts form drop down
Hi all,
can anyone help me to create charts from data in a drop down box? the chart is common. when the user select a particular item, the corresponding data should be displayed in the chart.(x and y axis same for all, only data value changes) Thanks in advance for your advice. Jithu. |
Charts form drop down
I find it hard to follow what it is that you are actually saying. Are you
trying to create a chart of a number of values from only one dropdown or from a number of dropdown boxes? -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Jithu" wrote in message ... Hi all, can anyone help me to create charts from data in a drop down box? the chart is common. when the user select a particular item, the corresponding data should be displayed in the chart.(x and y axis same for all, only data value changes) Thanks in advance for your advice. Jithu. |
Charts form drop down
Hi,
Have a look at Jon's example of changing chart content with controls. http://peltiertech.com/excel/charts/ChartByControl.html Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Jithu" wrote in message ... Hi all, can anyone help me to create charts from data in a drop down box? the chart is common. when the user select a particular item, the corresponding data should be displayed in the chart.(x and y axis same for all, only data value changes) Thanks in advance for your advice. Jithu. |
All times are GMT +1. The time now is 08:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com