Creating a chart then unlinking it from data?

[daveh]

Hi,

I am creating a chart based on some information on a worksheet, and then want the chart to remain as it is, even if it alter (or even delete) the data from which it was created. Obviously I could copy and paste the chart into a different application, making sure I don't link it, but what I was really hoping to do was to create the chart within excel, and then for it to be de-linked, as it were!

The chart is created using a macro, so I can obvioulsy use any vba code that may be able to do this upon chart creation.

Thanks in advance,
David.

 

[SkipVought]

Hi,

Just modify you code to assign an array of values to each series rather than assigning to a range.

Please post the code.

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}

 

[asrisk]

You could copy the chart as a picture, delete the chart and then paste the picture.

Select the chart, and then

ActiveChart.CopyPicture Appearance:=xlScreen, Size:=xlScreen, Format:= xlPicture

...and then paste it where you want, and delete the original.

However you will no longer be able to edit any aspects of the chart.

Andy.

-------
I am not responsible for any "Sponsored Links" which may appear in my messages.

 

[daveh]

OK I think I'll try the last solution, this seems to be the best way to do things. Thanks everyone for your help - I may also try the array of values idea too!

Dave

 

[BlueHorizon]

Hi,
You can also try this: Click Insert/Object and select Microsoft Graph. Paste your data into the datasheet portion, and it isn't linked to anything.
HTH,

Best,
Blue Horizon

http://www.bluehorizontraining.com