Graphs Linked to Datasheet

sreeder

New Member
Joined
Aug 27, 2002
Messages
12
At the end of each month I compile a workbook which is made up of approx 20 spreadsheets. Some sheets are reports and some are graphs. The graphs are in excel which are emailed to me from other sources. Most typically the graphs are generated from data in another spreadsheet. The problem I am having is when I drag the spreadsheet with the graph into the final workbook I am compiling, the graph will typically loose its link to the datasource and then the graph no longer makes any sense. The only workaround I have come up with is to drag the spreadsheet with the data into the workbook as well and then hide the spreadsheet. This is very time consuming. Is there a way to turn a graph to "values" much in the same way as a spreadsheet?
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

jletourn

Board Regular
Joined
May 29, 2003
Messages
67
Have you tried the Save as Web Page... option from the File drop down menu?

You select
Selection: Chart
in the dialog box and then save the chart where you like. Afterwards open the saved chart(s) in excel and treat it just like a worksheet.

Hope this helps.

JtL
 

sreeder

New Member
Joined
Aug 27, 2002
Messages
12
Thanks! However, I seem to loose the print settings when I save as Web Page. Anyway around that?
 

Ben

New Member
Joined
May 23, 2002
Messages
37
Sreeder,
Have you tried copying the graphs as a picture into your other file.
To do this hold down shift key, select edit from menu bar, choose copy picture.
I usually choose as shown on screen from the appearance option.
Then just paste into place in the new workbook.

Hope this helps
Ben
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,094
Messages
5,768,051
Members
425,451
Latest member
JohnBrooksBiddle

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