excel charts

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Charts

Excel Charts

resolvedResolved · Low Priority · Version 2007

Paul has attended:
Excel Introduction course

Excel Charts

How can you isolate a chart from the figures, to gain a snap shot that does not change.

RE: Excel Charts

Hi Paul

Thanks for getting in touch. You can achieve this by converting the image into a picture.

Copy the chart (such as with a right-click > Copy), then look for the Paste button on the Home tab. On the Paste drop-down, choose "Picture". This will create a static image version of the chart. You can continue to modify the data underneath the chart and your image will not change.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Mon 22 Apr 2013: Automatically marked as resolved.


 

Excel tip:

Selecting blank cells within a range of data

Select the range of data which includes the blank cells that you would like to select. Press the F5 key, this will take you to the GoTo dialogue box where you can click on Special and then select Blanks.

View all Excel hints and tips


Server loaded in 0.08 secs.