Whats the easiest way to format painter for chart data point

[Sahil123]

Hi all

i have several of charts where i have formatted some points using a graduent fill effect linear.

what i want to do is copy this colour and format painter it on a data point on another chart (not whole chart) and also format painter a cell and shape with this colour.

What is the best way to do this because its a nightmare Having to format them 1 by 1

thanks

 

[FDibbins]

I don't think you can use FP like that, in charts. You will probably need to apply the formatting manually - unless the charts are similar enough that you can copy 1, then change the data ranges?

 

[thisoldman]

The trick for the charts may be to use a dummy series and then Copy–> Paste Special + Formats. I've used column charts here.

The original data is used in each chart for Series 1. Series 2 will be the highlighted point.

[TABLE="class: grid"]
<tbody>[TR]
[TD="class: xl66"]Chart 1[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63, width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl64"][/TD]
[TD="class: xl64"]Data1[/TD]
[TD="class: xl64"]Gradient[/TD]
[/TR]
[TR]
[TD="class: xl65"]Alpha[/TD]
[TD="class: xl65, align: right"]7[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"]Beta[/TD]
[TD="class: xl65, align: right"]3[/TD]
[TD="class: xl65, align: right"]3[/TD]
[/TR]
[TR]
[TD="class: xl65"]Gamma[/TD]
[TD="class: xl65, align: right"]4[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[/TR]
[TR]
[TD="class: xl66"]Chart 2[/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[/TR]
[TR]
[TD="class: xl64"][/TD]
[TD="class: xl64"]Data1[/TD]
[TD="class: xl64"]Gradient[/TD]
[/TR]
[TR]
[TD="class: xl65"]Delta[/TD]
[TD="class: xl65, align: right"]17[/TD]
[TD="class: xl65, align: right"]17[/TD]
[/TR]
[TR]
[TD="class: xl65"]Epsilon[/TD]
[TD="class: xl65, align: right"]15[/TD]
[TD="class: xl65"][/TD]
[/TR]
[TR]
[TD="class: xl65"]Zeta[/TD]
[TD="class: xl65, align: right"]12[/TD]
[TD="class: xl65"][/TD]
[/TR]
</tbody>[/TABLE]

Chart 1
1a – A normal column chart is created. I've set the gap width to 70%.
1b – Series 2 is formatted.
1c – Series overlap is set to 100%.

Chart 2
2a – A normal column chart is created; gap width to 70%.
2b – Select the chart with the correctly formatted point, Chart 1c here, and copy it. Then select the chart you wish to change. From the Home tab on the ribbon, use the dropdown menu below the large paste icon and select 'Paste Special'. In the popup dialog, select 'Formats' and press OK. The results are as shown below.

To copy the gradient fill to a cell interior fill would require some VBA. It would be faster for me to set the cell fill manually than to write the code.