Can Chart Parameters be Applied from One Chart to Another?

User avatar
BobH
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?

Post by BobH »

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.

:cheers: :chocciebar: :thankyou:
Bob's yer Uncle
(1/2)(1+√5)
Dell Intel Core i5 Laptop, 3570K,1.60 GHz, 8 GB RAM, Windows 11 64-bit, LibreOffice,and other bits and bobs

User avatar
HansV
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?

Post by HansV »

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.
Best wishes,
Hans

User avatar
BobH
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?

Post by BobH »

Thank you, Mr. V!
Bob's yer Uncle
(1/2)(1+√5)
Dell Intel Core i5 Laptop, 3570K,1.60 GHz, 8 GB RAM, Windows 11 64-bit, LibreOffice,and other bits and bobs