Using Excel charts with high image quality in the Access environment

[aref]

Hello
In the attached example, I have used Excel environment charts in Access as images.
But the quality of the output images is very low.

Please help me how can I use Excel quality output images in Access.

My second issue is related to the "Please Wait..." box that I want to be placed in the middle of the page after the form is opened.

Thank you

 

[June7]

Does this help https://spreadsheetplanet.com/save-excel-chart-as-image/

Otherwise, this chart is simple enough to build in Access.

What about "please wait" box?

 

[aref]

Hi, thanks

I need vba code for high resolution chart export in excel and display high quality in access form.


In this sample attached,

"please wait" box in form is behind

I want to be placed in the middle of the form after loading form

 

[June7]

I can't find any such code. The referenced article is best I can find. Implication is that you cannot export directly to jpg and control the resolution. It is what it is.

Why are you opposed to building chart in Access? I did a test with your data and it looks quite nice. And faster.

Should have at top of each code module:
Option Compare Database
Option Explicit

 

[arnelgp]

here try your lab_message label.

 

[June7]

Nice, arnel. I tried to implement in original version of db and it won't set the Left property. What's the trick?

BTW, since you have With Me.Lab_Message, no need to repeat Me.Lab_Message in the expressions.

 

[isladogs]

I haven't looked at either of the databases in this thread.
My recommendation would be to avoid using JPG files as they are a 'lossy' format as often don't render well in Access.
Suggest using PNG instead