• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Chart Colour

C

cyliyu

Member
I have a pivot table and created a bar chart.
I would like to have the bars colour set to "Red" when the value is Open and "Green" when the value is Closed.
Need help please. Thanks.
 
Hi ,

One way is to have two series ; one series will have the bar values when the criteria value is Open , and when the criteria value is Closed , these same bar values will be NA() ; for the other series , it will be the other way around with the series having NA() when the criteria value is Open , and the bar values when the criteria value is Closed.

Plot both of these series , and manually set one series to red color and the other series to green color.

If this is not helpful , upload your workbook with the data and the pivot table and chart in it.

Narayan
 
Thanks for your reply.
I upload the sample file.
I want the bar chart to change those Close to Green and Open to Red Color.

EDIT: Attachment removed due to sensitive data
 
Last edited by a moderator:
You'd need to set Status as Column field.

This will create two series. I'd then change chart to stacked column chart and set color for each status.

EDIT by Mod: Attachment removed due to request from OP, accidental submission of sensitive data
 
Last edited by a moderator:
You must log in or register to reply here.
Back
Top