1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. 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...

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

Help Needed in making 3D Pie Charts and Bar Charts

Discussion in 'Discuss Data Visualizations and Charting' started by vk7, Apr 21, 2018.

  1. vk7

    vk7 Member

    Messages:
    33
    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.

    Attached Files:

  2. GraH - Guido

    GraH - Guido Active Member

    Messages:
    612
    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...

    Attached Files:

    vk7 likes this.
  3. vk7

    vk7 Member

    Messages:
    33
    @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!
  4. GraH - Guido

    GraH - Guido Active Member

    Messages:
    612
    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.

    Attached Files:

    vk7 likes this.

Share This Page