How to group X-axis in a bar chart?

Hi all,

Hope all's well.

In the attached file, purpose of chart with title nRFT Weekly % is to show values of Columns X in blue and Column Y in red.

However, I want the weeks to appear once as similar to the one in chart nRFT Weekly Tasks. Now this is a bit difficult because in such case, the average % value has to be identified for that particular week. I am unsure how to do that.

On the other hand, chart with title nRFT Weekly Tasks is linked to pivot and therefore automatically groups the weeks. Unfortunately i couldn't find a way to display columns % in columns X and Y in pivot.

I just want that the chart with title nRFT Weekly % to show weekly percentage which is calculated by dividing total count of Column V by total count of Column U on weekly basis.

Ex. For Week 1 of Feb, it will be 3/84 = 3.57%

Can someone please help

Brilliant JeteMc

Just 2 queries.

1. I have the same fields under Axis i.e Column 1 and Week Number, however they appear in same column whereas it shows in different columns in your file like Feb in 1 column and week numbers in 2nd column. May i know how to do that?

Attachment 824910

Attachment 824911


2. Any way that i can set color for bars in graph such that if % is less than 3, bars should be in green else red.


Can you help

@JeteMc

Many thanks again.

#1 Perfect

#2 I referred the link you shared and tried vary colors by point option and selected red color. However, all bars appear red. How did you set bar colors based on percentage

Sorry, but may i also know how did you get Sum of weekly % in Values field?


@MrShorty

Thanks for your response

May i please know what formula to be added in Calculated Field?

Attachment 825006

Thanks a ton for answering all queries JeteMc. Really appreciate your kind response each time.