Charts

berg891832 · May 23rd, 2002, 08:19 PM

Let's say I have to identical worksheets. When make a chart on one sheet then copy the chart to the other sheet, the source data does not reflect sheet2's info. Is there anyway around this?
Bill

PaddyD · May 23rd, 2002, 08:53 PM

Bill,

There are no doubt more 'automatic'ways to do this, but the follwing is fairly straightforward:

1) Copy the chart to you new sheet
2) Right click - select source data
3) Select series.
4) Click the button that displays the cell references for your series
5) Click the sheet tab for your workbook - referneces are updated...

Hope this helps,
Paddy

Yogi Anand · May 23rd, 2002, 09:28 PM

Hi Bill:
You should also look at INSERT|CHART|then select Custom Types ... then select User-defined ... and then select Default or create your own Custom Type chart.

Regards!

May 23rd, 2002, 09:28 PM	#3
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	Hi Bill: You should also look at INSERT\|CHART\|then select Custom Types ... then select User-defined ... and then select Default or create your own Custom Type chart. Regards! __________________ Regards! Yogi Anand, D.Eng, P.E. Energy Efficient Building Network LLC www.energyefficientbuild.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 23rd, 2002, 08:19 PM	#1
berg891832 Board Regular Join Date: May 2002 Posts: 508	Let's say I have to identical worksheets. When make a chart on one sheet then copy the chart to the other sheet, the source data does not reflect sheet2's info. Is there anyway around this? Bill

May 23rd, 2002, 08:53 PM	#2
PaddyD MrExcel MVP Join Date: May 2002 Posts: 13,278	Bill, There are no doubt more 'automatic'ways to do this, but the follwing is fairly straightforward: 1) Copy the chart to you new sheet 2) Right click - select source data 3) Select series. 4) Click the button that displays the cell references for your series 5) Click the sheet tab for your workbook - referneces are updated... Hope this helps, Paddy