I need to embed an image/ graph to a spreadsheet via excel macro vba.
- Thread starter pranav
- Start date
Pranev
Firstly, Welcome to the Chandoo.org forums.
Whenever you make a Chart in an Excel spreadsheet the chart will stay with the spreadsheet regardless of where the file is located.
If the chart is based on data in another workbook and they are in the same directory the chart will update as long as the two files stay together.
If the charts don't stay together you can do a couple of things
1. When you shift the files, relink the data in the remote file using the Edit, Links menu command
or
2. Save the file as a Picture, although this then doesn't update if the data changes
My preference is not to make charts linked to data from external files.
Firstly, Welcome to the Chandoo.org forums.
Whenever you make a Chart in an Excel spreadsheet the chart will stay with the spreadsheet regardless of where the file is located.
If the chart is based on data in another workbook and they are in the same directory the chart will update as long as the two files stay together.
If the charts don't stay together you can do a couple of things
1. When you shift the files, relink the data in the remote file using the Edit, Links menu command
or
2. Save the file as a Picture, although this then doesn't update if the data changes
My preference is not to make charts linked to data from external files.