A
Andy the yeti
Hi,
I have created a dynamic chart that updates using combo boxes on the chart.
(the combo boxes link to vlookups and update the data depending on the metric
I wish to see).
My issue is that when I click on other tabs within the workbook and come
back to the charts the combo boxes have moved and obscure either each other
or the chart title.
Do you have any idea how I can prevent this from happening?
Many thanks for any advice.
Andy
I have created a dynamic chart that updates using combo boxes on the chart.
(the combo boxes link to vlookups and update the data depending on the metric
I wish to see).
My issue is that when I click on other tabs within the workbook and come
back to the charts the combo boxes have moved and obscure either each other
or the chart title.
Do you have any idea how I can prevent this from happening?
Many thanks for any advice.
Andy