I have a Workbook that contains spreadsheets for each month. I've propagated the headings, format, and formulas from the first spreadsheet across the other eleven.
I have a chart in the first spreadsheet. I'd like to be able to propagate the chart particulars to the other spreadsheets but have the chart reflect data from each spreadsheet separately. IOW, I'd like to avoid having to set up the same chart particulars - other than data - on each of the other spreadsheets.
Is this possible? I've become very confused reading articles on the web.
Can Chart Parameters be Applied from One Chart to Another?
-
- UraniumLounger
- Posts: 9266
- Joined: 13 Feb 2010, 01:27
- Location: Deep in the Heart of Texas
Can Chart Parameters be Applied from One Chart to Another?
Bob's yer Uncle
Dell Intel Core i5 Laptop, 3570K,1.60 GHz, 8 GB RAM, Windows 11 64-bit, LibreOffice,and other bits and bobs
(1/2)(1+√5) |
-
- Administrator
- Posts: 78415
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Can Chart Parameters be Applied from One Chart to Another?
Select the first chart.
Copy it (Ctrl+C).
Select a chart on another sheet.
Click the lower half of the Paste button on the Home tab of the ribbon.
Select Paste Special...
Select Formats, then click OK.
Copy it (Ctrl+C).
Select a chart on another sheet.
Click the lower half of the Paste button on the Home tab of the ribbon.
Select Paste Special...
Select Formats, then click OK.
Best wishes,
Hans
Hans
-
- UraniumLounger
- Posts: 9266
- Joined: 13 Feb 2010, 01:27
- Location: Deep in the Heart of Texas
Re: Can Chart Parameters be Applied from One Chart to Another?
Thank you, Mr. V!
Bob's yer Uncle
Dell Intel Core i5 Laptop, 3570K,1.60 GHz, 8 GB RAM, Windows 11 64-bit, LibreOffice,and other bits and bobs
(1/2)(1+√5) |