December 29, 2016
Hi all!
I have a doubts: (see attach please)
1) I created a chart named XXX with certain colours. I need to copy the formats for other charts - ddd, ooo... I can copy one by one when I did copy special - paste formats. But if I have 20 charts, i will copy one by one and the process is time consuming.
Can you help me please? Is there any way to automate formatting for multiple graphics? (sheet option 1)
2) The third quarter (3T) is finished and I want that in sheet option 2 (3T) bar become grew, how I can do this? How can i change the colour automatically to higlight the current month?
Thanks in advance 🙂
Hava
July 16, 2010
Hi Hava,
There was no file attached but from what you describe you can use Chart Templates.
If you have any problems please let me know.
Mynda
Answers Post
VIP
Trusted Members
June 25, 2016
Hi Hava
Q1 - One way is to copy and paste the format to 1 chart. Then select all other charts individually and press the F4 function key to repeat the process. No need to re-copy and paste.
Q2 - To create different color bar(s) you will need to create a new series (e.g. Series B) for that particular value and then create a stacked column chart.
In the example below, Apr will have a different color bar.
Jan Feb Mar Apr May
Series A 1 1 1 1
Series B 1 <----Different series so different color bar
Hope this helps.
Sunny
1 Guest(s)