Forum

Notifications
Clear all

Format Graphs

5 Posts
3 Users
0 Reactions
62 Views
(@hava)
Posts: 41
Trusted Member
Topic starter
 

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

 
Posted : 09/10/2017 11:14 am
(@mynda)
Posts: 4761
Member Admin
 

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

 
Posted : 10/10/2017 7:34 am
(@hava)
Posts: 41
Trusted Member
Topic starter
 

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?

 
Posted : 12/10/2017 4:45 pm
(@hava)
Posts: 41
Trusted Member
Topic starter
 

Attach. Many thanks.

 
Posted : 12/10/2017 4:51 pm
(@sunnykow)
Posts: 1417
Noble Member
 

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

 
Posted : 12/10/2017 8:21 pm
Share: