How to paste a spreadsheet as a graphic and have it linked.

SDKBRK

Board Regular
Joined
Feb 1, 2003
Messages
162
I have a spreadsheet that I have copied and pasted as a graphic but I need it to be linked to its orginal worksheet. So when I update the spreadsheet it will automaticlly update the graphic.


The way I did the graphic is I held down the Shfit Key, highlighted the cells, click on edit, copy picture, click ok, Edit, Paste

How do I make it link?

Thanks.
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

Steve Hartman

Active Member
Joined
Feb 17, 2002
Messages
417
Re: How to paste a spreadsheet as a graphic and have it link

What are yoou pasting it into? If it's Word, instead of paste use paste special. It will give you a list of options for the pasted format and you can chose to paste as a link.
 

SDKBRK

Board Regular
Joined
Feb 1, 2003
Messages
162
Re: How to paste a spreadsheet as a graphic and have it link

I'm pasting into another worksheet in the same file.
 

kkknie

Well-known Member
Joined
Apr 29, 2002
Messages
677
Re: How to paste a spreadsheet as a graphic and have it link

Why not just copy it? It would basically be a duplicate of the first chart.

Backup. This will work if you are only changing the data, but if you ever change the chart, it will not be the same. You could just record the steps that you take to copy the chart once and then run that macro if you change it.

K

P.S. Steve: Love your tag-line. :LOL:
 

Tom Urtis

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,224
Re: How to paste a spreadsheet as a graphic and have it link

This sounds like a perfect opportunity for an ActiveX spreadsheet control. You can get it off the ActiveX control toolbox and draw it on your sheet (or on a userform but it looks like you want to see it on your sheet interface).

This control is not too common, so if you don't see it, right click the "More controls" icon on the toolbox, and double-click "Microsoft Office Spreadsheet 11.0" (or 10.0 if you are using Excel2002). Then, use a worksheet change event in your sheet module to update the range you want...modify for source sheet name, target range and spreadsheet control name. Works fine for me when tested.

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A1:B10")) Is Nothing Or Target.Cells.Count > 1 Then Exit Sub
Dim rngSource As Range
Dim rngTarget As Object
Dim rng As Range
Set rngSource = Worksheets("Sheet2").Range("A1").CurrentRegion
Set rngTarget = Spreadsheet1.Cells.Range(rngSource.Address)
With Spreadsheet1
rngTarget.Value = rngSource.Value
End With
For Each rng In rngSource.Rows(1).Columns
rngTarget.Columns(rng.Column).ColumnWidth = rng.Width
Next rng
End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,122,483
Messages
5,596,405
Members
414,064
Latest member
Duncthegreat

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top