Help Needed in making 3D Pie Charts and Bar Charts

[vk7]

Hello,

Please refer the attached excel workbook containing 3 columns.

Bank Account Number
Branch Location
Account Opened By Official.

Pie Chart
I would like to have a 3D Pie Chart representing Branch Location and how many accounts each location has.

Bar Chart or any other better charting
Each customer account is opened by some bank official where their name is mentioned in column3. It would be great if we can make a bar chart or any other better charting to represent how many accounts each official has opened.

 

[GraH - Guido]

Hi,
Simplest via pivot charts I guess.
Bar charts in attached.
Did not make the 3d pie: pie's are over utilized and overrated. Read the blog article on selecting the best chart type for your data.
Sorry for being so brief, I had to go...

 

[vk7]

@GraH - Guido, thank you for helping me out. I am not sure which blog article that you are referring out. I couldn't find the right one to. Could you please point me to the right one if you have the link handy.

Also, it would be great if I can get one example for making pie-chart for my data and I will be able to customize it. Thnk you in advance!

 

[GraH - Guido]

Hi, select the current pivot chart and change chart type via the right mouse click menu and select pie form the gallery.
Alternative to a pivot chart, is using the pivot + conditional formatting.

The article I referred to is this one:
https://chandoo.org/wp/2010/04/19/chart-selection-process/
A bit more elaborated: https://eazybi.com/blog/data_visualization_and_chart_types/
and Jorge has some insights on that to share as well @ https://excelcharts.com/
Cannot do without the tips one of the charting masters, Jon Peltier: https://peltiertech.com, he has some importing things to say about 3-D.