If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
Hi friends,
I am quite new this forum. Wondering here for a solution which forced me to post it here. I have created a macro which produce a chart dynamically between the selected cell values on a separate sheet. One more thing i want to add is, how can i add an image to the chart (say logo) using macro so that it will be shown for every chart pages that it creates. Even will be interested if any extra text can be added in the same way. Thanks in advance.
Sub Chart()
Dim myRange As Range
Set myRange = Range("A4:A13")
Charts.Add
ActiveChart.ChartType = xlRadar
ActiveChart.SetSourceData Source:=myRange, _
PlotBy:=xlColumns
End Sub
when this sub assigned to a button, it works fine however i want an image to be produced with the new sheet.
Thanks
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
Try using the macro recorder when inserting picture into chart sheet.
Linear Mode
