Copying A Chart

  • Thread starter Thread starter Mathew
  • Start date Start date
M

Mathew

Good Evening All,
I have come across a problem, which I cannot seem to resolve, and am hoping there is an easy fix for this.
(Already trawled Google).

I have a worksheet which incorporates a chart, the source data of which is from the same sheet,
however, I simply wish to copy/paste the chart into another sheet, (as in copy/pastespecial/vaules only),
where the sheet will appear just as is and all links to source data is removed. (This is for e-mail purposes
where I do not wish to also provide the source data).
I do not want to copy into Word or Powerpoint.
(This must be simple, any help most appreciated as usual)

Thank you
Mathew
 
Hi Mathew,
Click on the chart to 'activate' it.
Hold down SHIFT key
Use menu command Edit and locate Copy Picture (only there if you held Shift
down)
Selects either As on Screen or As Printed (not much difference)
Go to new locale (it could be Word, PPT, WordPerfect, CorelDraw, etc) and
Paste
You have a picture of the chart
Best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in e-mail address
Mathew said:
Good Evening All,
I have come across a problem, which I cannot seem to resolve, and am
Click to expand...
hoping there is an easy fix for this.
(Already trawled Google).

I have a worksheet which incorporates a chart, the source data of which is from the same sheet,
however, I simply wish to copy/paste the chart into another sheet, (as in
Click to expand...
copy/pastespecial/vaules only),
where the sheet will appear just as is and all links to source data is
Click to expand...
removed. (This is for e-mail purposes
 
Back
Top