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.
It's not clear whether you want a shape embeded in the chart or printed page.
Can you post example workbook it illusrate where the shape would be placed.
Hello.. the macro code goes here..
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks