ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Add drop down menu into Chart (https://www.excelbanter.com/excel-discussion-misc-queries/237656-add-drop-down-menu-into-chart.html)

Dave

Add drop down menu into Chart
 
Hi,

Is it possible to add a drop down menu into a chart which can link to the
data I am using.

Thanks

Andy Pope

Add drop down menu into Chart
 
Hi,

Maybe this will help.
http://peltiertech.com/Excel/Charts/ChartByControl.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Dave" wrote in message
...
Hi,

Is it possible to add a drop down menu into a chart which can link to the
data I am using.

Thanks



Dave

Add drop down menu into Chart
 
Hi Andy

Unfortunately, this is of no use. I need to be able to place the drop down
in the actual chart sheet

Thanks

"Andy Pope" wrote:

Hi,

Maybe this will help.
http://peltiertech.com/Excel/Charts/ChartByControl.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Dave" wrote in message
...
Hi,

Is it possible to add a drop down menu into a chart which can link to the
data I am using.

Thanks




Andy Pope

Add drop down menu into Chart
 
Hi,

If you use Form controls rather than ActiveX controls then you can place
them on a chart sheet or within an embedded chart object.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Dave" wrote in message
...
Hi Andy

Unfortunately, this is of no use. I need to be able to place the drop down
in the actual chart sheet

Thanks

"Andy Pope" wrote:

Hi,

Maybe this will help.
http://peltiertech.com/Excel/Charts/ChartByControl.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Dave" wrote in message
...
Hi,

Is it possible to add a drop down menu into a chart which can link to
the
data I am using.

Thanks






All times are GMT +1. The time now is 04:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com