View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier[_9_] Jon Peltier[_9_] is offline
external usenet poster
 
Posts: 146
Default Break Chart Links

Peter -

Does it make use of the xlusrgal.xls file? I was using that technique
for a while, and now I can't save any new user defined chart types.

If it doesn't use xlusrgal.xls, I'd be appreciative if you sent me a
copy of your routine. delete the caps from the From email.

Thanks,

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______



Peter T wrote:

Do your series have many values perhaps. A while ago I put together a
de-link chart routine which seems to work with series of at least 10,000
values, each with long value lengths, say 16 digits. Converts all data on
the chart to named arrays, with a separate routine to reconvert to cells in
same book and reconstruct if required. Not sure if this would overcome your
problem but you're welcome to try if interested.

Regards,
Peter T

pmbthornton at gmail com


"Ashleigh Gardner" wrote in
message ...

Jon,

Thank you for the suggestion. I believe my series arrays are being formed
properly; however, when I try to set the formula property, I get the
following error:

(ChtSeries.Formula = ...)
Run Time Error '1004': Unable to set the formula property of the series


class

The string I am trying to store as a formula is 429 characters long. From
what I understand, the limit is 1024 characters. Therefore, I don't know


why

I get an error.

Have you seen this behavior before?

"Jon Peltier" wrote:


Delinking Chart Data:
http://peltiertech.com/Excel/ChartsH...ChartData.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Ashleigh Gardner wrote:


I have a template with several embedded linked charts. After updating


values

in the linked workbook, I wish to update my charts and then break all


links

(so that further changes in the linked workbook are not reflected in


the

charts).

I have tried, for example:
ActiveWorkbook.BreakLinks Name:=linkFileName,


Type:=xlLinkTypeExcelLinks

This does not seem to have any impact on the chart links.

I have also tried converting each chart series into an array; however,


each

formula requires significanly more than 256 characters to accurately


generate

the chart.

I have thought about converting each chart into an image after


updating, but

I am not sure how to code something like this. Any suggestions or


methods of

breaking chart links would be greatly appreciated!