Updating pivot tables with new data Chat xxx serbija
Charts can reside as standalone sheets within a workbook, but they can also be embedded in other sheets (worksheets, chart sheets, and dialog sheets).
Drawing on more than 30 combined years of Excel experience, they provide tips and tricks you won't find anywhere else, and show exactly how to sidestep common mistakes.The references in the chart did not change, so the pasted chart still referenced the original data.Instead of copying just the chart, this time copy the sheet with its chart.Chart Embedded on Different Worksheet From its Data When you have data on one worksheet and its chart embedded on another, it looks like this.
The series formula for the selected series in the chart on Sheet2 references the data on Sheet1.
But to our chagrin, the chart in ‘Sheet2 (2)’ still references the data in ‘Sheet1’, not that in ‘Sheet1 (2)’. The copy could be made using Save As from the File menu, or by making a copy in Windows Explorer.