Hi All
How can I create and maintain charts from Sheets 2 and 3 (for example), but also copy and see any changes made over to sheet 1? So if I change sheet 2 data, resulting in a change to the chart, I'd like the change to show on Sheet 1 without having to do anything. I'd also like to regularly change headings which should be carried to sheet 1 too (if this requires anything different, but I'm hoping ANY change to the chart will be reflected on the main sheet (Sheet 1))
Thanks in advance
Bookmarks