both a chart and a gauge (an activeX)

Hello,

I've built an application where both a chart and a gauge (an activeX)
appear on the same sheet. When trying to update the chart values fron
another sheet on the same workbook, i use the "source data" that takes me to
the sheet with the data. But when i perform this operation, the gauge from
the activeX remains on the window and hides a part of the sheet with the
data.

Is there some way to overcome the problem?

Many thaks



Avi Benita 054-4660641 wwwAvi Benita 054-4660641 www.avibenita.com

I'm not so clear about your case. Maybe you can move "gauge" and then enter
the source data dialog.Or if you will, you can upload your excel file and
let me see?