Skip to Content

Coloring Chart Series Based on the Drill down Selection

Like the image below , the coloring series based on the selection made in the above chart (pie chart here) , the “series color” of the below chart (drill down chart-column chart here) can be changed.

This trick can be followed for any chart. To do this, follow the simple steps below.

Capture61.PNG

  1. Drag a chart and map values to it, enable data insertion.

Capture62.PNG

2.     Map the Drill down data, and destination. The destination(yellow colored row here) of this drill down will be the values shown in the column chart here.

Capture65.PNGCapture63.PNG

3.     In the appearance tab, select the series colors such that, when a particular selection is made in the main chart, that selected color is shown in the chart down below (column chart here). Note the RGB values of these colors, and put it in columns along with the data labels (column E and F here as shown below).

The RGB color formatting should be in this format

=”(255,25,1)”

In the cell F7 (yellow colored cell) write a formula to pick the selected color.

=vlookup(A15,E6:F6,2,False)

Capture64.PNG

Column Chart Linking:

The destination of the drill down is to be linked to the column chart.

Capture66.PNG

The series color of the column chart is to be bound to the cell having the formula (yellow colored cell here in the image below).

I have attached sample file with it. change the extension to “.xlf” to view the file.

Capture67.PNG

And thats how it is done.

Thanks,

Sara

14 Comments
You must be Logged on to comment or reply to a post.