How to create percentile bar chart?

[AnandaBalan]

Hi,

I would like to create a bar chart graph which shows the percentage of positive results in overall result.

I have attached an example question in this.

Thanks in advance.

 

[Somendra Misra]

Hi Ananda,

Will you post the expected result also, which you want to plot??

Regards,

 

[AnandaBalan]

Hi Somendra,

I have attached my question above. I would like to show a bar chart that I have delivered 6 out of 10 times within time. This should be taken from results column.

 

[Somendra Misra]

Something like this.



Regards,

 

[AnandaBalan]

Hi Somendra,

Thanks for the effort.

I would like to see other way. I have attached some more details in a new sheet. I tried to explain some more details of the requirements.

I would like to see a chart as in in the second sheet. Is that possible?

 

[Somendra Misra]

See the file.

Regards,

 

[AnandaBalan]

Hi Somendra,

Thank you. This is what I was looking.

 

[AnandaBalan]

Hi Somendra,

Thanks for the help, Is it possible to create same chart with pivot table?

Please see attached file:
If I create the same chart using pivot table, I can add slicers. In the attached sheet, if I have to see the chart only for a MSN, I can slice the data.

The chart whats shown is correct, is it possible to do using pivot table?

Thanks again for your help.

Regards,
Anand

 

[Somendra Misra]

Hi Ananda,

I am unable to produce the result through PC, but if you can tell your requirement that what slicer you want, than may be I can walk through some others means.

Regards,

 

[AnandaBalan]

Hi Somendra,

I have attached a snapshot of my excel sheet.
The chart shown on the right side is same as what I was expecting. But this chart has been created using charts in Excel, can we create the same chart using pivot table?

My requirements:
Shown chart is created by percentage formula and countif functions.
Shown chart is for all customers, say Google, Yahoo and MSN....
Is it possible to create same chart using pivot chart? So that I can create slicers.
If I have to see the chart only for MSN, I need to create a seperate chart now.
If I have to view results for MSN and Yahoo together, now I have to create a seperate table and chart.

I hope I have explained my requirements clearly.

Thank you again.

Regards,
Ananand

 

[Somendra Misra]

@AnandaBalan

See the file, on sheet 2. Well the chart is not Pivot chart, but created with old technique but you can make it dynamic with slicer.

Regards,

 

[AnandaBalan]

This will help definitely.
Thank you Somendra.

 

[Somendra Misra]

You are Welcome..

Regards,