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
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
Hi Mynda. Sorry for not attach the document.
I attach the document now.
Chart Templates are useful but I need to constantly save templates for any chart I want. Can you help me with my document/example please?
Attach. Many thanks.
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