Good day, Excel peeps...!
I'm currently struggling with a problem of which I'm uncertain there's a perfectly desirable solution. The background is that I have a macro which creates six scatter charts and modifies each of them so that their gridlines, axis etc are consistent with eachother. As information elsewhere in the file is edited, these axis can end up with different maximum and minimum values.
I am aiming to insert a cropped version of a picture within the plot area, where the cropping is based upon maximum and minimum values of each axis. I'm reasonably sure I'm able to crop a picture correctly, however the only way I can find to set a plot area's fill to be a custom picture is if I tell VBA to find the picture from within a folder and upload it, like this:
For Each chChart In Worksheets("Charts").ChartObjects
chChart.Chart.PlotArea.Format.Fill.UserPicture ("Original1.bmp")
Next chChart
I have recently discovered that I'm able to name pictures, as well as copy, paste and crop them. My higher-ups wouldn't be too happy if I started saving images in their folders and it's a rather messy workaround; is there any way to set the user picture to be a picture that is already in the Excel file?
Thank you for your time~!
I'm currently struggling with a problem of which I'm uncertain there's a perfectly desirable solution. The background is that I have a macro which creates six scatter charts and modifies each of them so that their gridlines, axis etc are consistent with eachother. As information elsewhere in the file is edited, these axis can end up with different maximum and minimum values.
I am aiming to insert a cropped version of a picture within the plot area, where the cropping is based upon maximum and minimum values of each axis. I'm reasonably sure I'm able to crop a picture correctly, however the only way I can find to set a plot area's fill to be a custom picture is if I tell VBA to find the picture from within a folder and upload it, like this:
For Each chChart In Worksheets("Charts").ChartObjects
chChart.Chart.PlotArea.Format.Fill.UserPicture ("Original1.bmp")
Next chChart
I have recently discovered that I'm able to name pictures, as well as copy, paste and crop them. My higher-ups wouldn't be too happy if I started saving images in their folders and it's a rather messy workaround; is there any way to set the user picture to be a picture that is already in the Excel file?
Thank you for your time~!
