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!
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
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?
Regards,
Peter T
pmbthornton at gmail com
"Ashleigh Gardner" <Ashleig...@discussions.microsoft.com> wrote in
message news:6008882F-89C3-4C77...@microsoft.com...
> Sounds like you overcame a similar problem, so I'd love to see how.
Thanks!
Horizontal array 256, vertical array 64k. But there's a bit more to it.
I've just sent you what I have.
Regards,
Peter
"Ashleigh Gardner" <Ashleig...@discussions.microsoft.com> wrote in
message news:3D8EDAFE-F906-4EE3...@microsoft.com...
> Peter,
>
> The routine you have written sounds very promising. Basically I have
> several charts, each with 2 data series. There are 26 data points per
> series, but each value has 16 digits. After delinking these series and
> converting to strings, I far exceed the 255 character limit of VBA's
> seriesformula property.
>
> Sounds like you overcame a similar problem, so I'd love to see how.
Thanks!
Well I tried to but didn't notice you are "@discussions" same as me. Either
email me direct (see bottom of my first & this reply) or post your address
here.
Peter T
pmbthornton at gmail com
"Peter T" <peter_t@discussions> wrote in message
news:OLX9Mp#gFHA...@TK2MSFTNGP14.phx.gbl...
-Nick
nickbowman at yahoo.com
--
nbowman
------------------------------------------------------------------------
nbowman's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25152
View this thread: http://www.excelforum.com/showthread.php?threadid=385283
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/
_______
> 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.
No nothing like that, guess you mean store a custom chart. I hadn't thought
of that but not sure I'd want to put loads of UD charts with many values
there, in any case wouldn't be transportable.
As I mentioned to the OP, named vertical arrays, eg
vertical {1;2;3}
vs
horizontal {1,2,3}
> 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.
I've just sent you my routine, also sample a chart with some "long" series
to test with.
Nick - I have also cc'd same to you.
Regards,
Peter T