Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting chartsheets and breaking links
Is it possible to export chartsheets and break their links. I have in
the past exported all the chartsheets from Workbook1 as Gifs and placed them in Workbook2. The result is that all the charts get copied as Gifs and then placed in Workbook2 in succession (i.e. vertically down the 1 sheet). The problem with copying them as Gifs is that you cannot click onto the series after the fact. Furthermore, since they are all on the same sheet, the user has to scroll down to view them. I want to copy the chartsheet and then export it as chart sheet (not gif) into Workbook2. Final result will be a new workbook with its own chartsheets with no links. Can this be done? --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting chartsheets and breaking links
You can apply the techniques in this web page to chart sheets:
http://peltiertech.com/Excel/ChartsH...ChartData.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ ExcelMonkey < wrote: Is it possible to export chartsheets and break their links. I have in the past exported all the chartsheets from Workbook1 as Gifs and placed them in Workbook2. The result is that all the charts get copied as Gifs and then placed in Workbook2 in succession (i.e. vertically down the 1 sheet). The problem with copying them as Gifs is that you cannot click onto the series after the fact. Furthermore, since they are all on the same sheet, the user has to scroll down to view them. I want to copy the chartsheet and then export it as chart sheet (not gif) into Workbook2. Final result will be a new workbook with its own chartsheets with no links. Can this be done? --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting chartsheets and breaking links
Correct me if I am wrong but this only tells me how to break the links
of the series. So I still need to copy sheet from workbook1 to workbook2. Furthermore, I sometimes use cell links for my titles. Does this break the links for the cell links as well? --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exporting chartsheets and breaking links
Yes, what I posted breaks series links. To unlink the titles, you'd need
something like this: Sub UnlinkTitles() Dim iAx As Integer, iGrp As Integer With ActiveChart If .HasTitle Then .ChartTitle.Text = .ChartTitle.Text For iAx = 1 To 2 For iGrp = 1 To 2 If .HasAxis(iAx, iGrp) Then With .Axes(iAx, iGrp) If .HasTitle Then _ .AxisTitle.Text = .AxisTitle.Text End With End If Next Next End With End Sub Copying the chart sheet is straightforward: Sheets("Chart1").Copy Befo=Workbooks("OtherBook.xls").Sheets(1) You can record a macro to find out things like this. In fact, that's what I did, so I didn't mess up the syntax. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ ExcelMonkey < wrote: Correct me if I am wrong but this only tells me how to break the links of the series. So I still need to copy sheet from workbook1 to workbook2. Furthermore, I sometimes use cell links for my titles. Does this break the links for the cell links as well? --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Breaking Links - BUT WHERE ARE THEY??? | Excel Discussion (Misc queries) | |||
Breaking links | Excel Worksheet Functions | |||
Breaking Links | Excel Discussion (Misc queries) | |||
Breaking Links | Excel Discussion (Misc queries) | |||
Breaking links | Links and Linking in Excel |