ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Can I use format painter (or F4) in a chart? (https://www.excelbanter.com/charts-charting-excel/31450-can-i-use-format-painter-f4-chart.html)

Artemis

Can I use format painter (or F4) in a chart?
 
For example, I want to change the colour of the chart, the background and the
legend on several charts - all to one new colour. Is there a quick way to
copy a format, like a colour or a font type/size?

Artemis

I have found a workaround to my own problem, it works fairly well. I used the
arrow keys to move between chart elements and when the one I wanted was
selected I could click on the fill colour quite quickly. Not as good as
format painter but will do for now!

"Artemis" wrote:

For example, I want to change the colour of the chart, the background and the
legend on several charts - all to one new colour. Is there a quick way to
copy a format, like a colour or a font type/size?



All times are GMT +1. The time now is 03:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com