Conditional Format Pivot Table Bar Chart

STEFAWN

New Member
Joined
Feb 16, 2017
Messages
13
Hello,
I'm trying to color code a pivoted bar chart so that 2016 data points are one color and 2017 data points are another color. The x axis has the dates Jan 2016 , Jan 2017, Feb 2016, Feb 2017 and this goes on an on for two years and is separated by different groups. So for example Jan-Dec 2016-2017 for group A then Jan-Dec 2016-2017 Group B. I'd like to visually show 2016 and 2017 months a different color when they are next to each other and do not want to select the individual points and color code each on.
Thanks!
Tawnee
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Forum statistics

Threads
1,214,932
Messages
6,122,334
Members
449,077
Latest member
Jocksteriom

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top