I made a simple dynamic graph, essentially presenting time (x-axis) against total value of shares (y-axis), where the price of a share can dynamically be set using a form control scroll bar. It all works great .
The scroll bar I placed in the area of the chart, and (even) grouped the bar to the chart.
The chart is an object in the spread sheet. When I use Design/Location/Move Chart and place the chart in a new sheet, the form control (as well as pictures inserted with the camera tool) disappeared.
My question is, how can I use Move Chart while retaining all other (non-chart) graphical elements in the chart?
The scroll bar I placed in the area of the chart, and (even) grouped the bar to the chart.
The chart is an object in the spread sheet. When I use Design/Location/Move Chart and place the chart in a new sheet, the form control (as well as pictures inserted with the camera tool) disappeared.
My question is, how can I use Move Chart while retaining all other (non-chart) graphical elements in the chart?