Graphs Linked to Datasheet

[sreeder]

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?

 

[jletourn]

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]

Thanks! However, I seem to loose the print settings when I save as Web Page. Anyway around that?

 

[Ben]

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