A picture is worth a thousand words, and since a graph is a picture of data, it is equally as valuable. To share that value with others, you must have the ability to share the graph with others so they may also benefit from the data. However, sharing the workbook that created the graph presents a security issue, and may expose sensitive information to users who do not need it. The next best option is to add your graph to an email to share with another.
In this recipe, you will learn to use VBA code to send your current graph as a static image to an email recipient hence preserving your data's security and privacy.
We will begin this recipe with a basic graph of transactions. The code in this recipe will send any graph regardless of the size or content.