Need way of changing graph line colour for multiple graphs

**hunterage2000** · 01-30-2016, 05:02 AM

I have a report with about 20 graphs in it on different sheets and I want to change a graph line colour on all graphs in one go instead of changing the colours one by one.

Can someone tell me if there is a way to do this? I have a very basic understanding of excel.

Many thanks.

**Andy Pope** · 01-30-2016, 06:12 AM

No way I'm afraid. You need to format each chart.
You might be able to speed things up with a little macro code.

**hunterage2000** · 01-30-2016, 06:22 AM

Okay thanks for letting me know, Cheers mate.

Need way of changing graph line colour for multiple graphs

LinkBack

Thread Tools

Rate This Thread

Display

Need way of changing graph line colour for multiple graphs

Re: Need way of changing graph line colour for multiple graphs

Re: Need way of changing graph line colour for multiple graphs

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Fill graph area between 2 line graphs

[SOLVED] Adding two vertical line graphs to a bar graph

Excel 2007 : Text in graphs changing colour randomly

Changing Colors of the Line Segments within a Scatter Graph Line

Stacked Bar Graphs with dual axes and a line graph.

Multiple colour line graph

[SOLVED] Colour part of a line on an X Y graph

Bookmarks

Bookmarks

Posting Permissions