Method Save the chart as a file

Just because Microsoft doesn't allow a live chart to be displayed in a UserForm doesn't mean it can't be done! Figure 15-12 shows a UserForm with a chart displayed in an Image object. The chart actually resides on a worksheet, and the UserForm always displays the current chart. This technique works by copying the chart to a temporary graphics file and then setting the Image control's Picture property to the temporary file. Read on to discover how.

Figure 15-12: With a bit of trickery, a UserForm can display "live" charts.
0 0

Post a comment